+ Reply to Thread
Results 1 to 3 of 3

Sum Vlookup

  1. 01-28-2014, 05:43 AM #1
    chloelee
    chloelee is offline
    Registered User
    Join Date
    01-28-2014
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    7

    Sum Vlookup

    Hi experts,

    Appreciate if you can provide me the formula on how to do a sum vlookup by multiple records.

    My table:
    Name Ticket 1 Ticket 2 Ticket 3
    ABC 5 4 3
    BCA 4 4 2

    i would like to search the name of ABC and sum all the tickets; the final result is ABC = 12. any suggestion?

    Thanks in advance.
    Reply With QuoteRegister To Reply
  2. 01-28-2014, 05:52 AM #2
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Sum Vlookup

    here are 2 ways use index or sum product see attached
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  3. 01-28-2014, 07:02 AM #3
    chloelee
    chloelee is offline
    Registered User
    Join Date
    01-28-2014
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Sum Vlookup

    Wow great... i got the result that i want, thank you very much Martin.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find max value in range then vlookup text in correspond col header & vlookup to table
    By jcskwells in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-26-2013, 01:12 PM
  2. Display Cell within VLookup range that excel thinks matches the VLookup Value
    By headachexcelperson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 04:56 PM
  3. [SOLVED] Vlookup is not working and giving =vlookup(B2,$T$2:$U$135,2,false) this kind of values.
    By yogeshsharma1981 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2013, 04:08 PM
  4. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  5. Howto: Vlookup looping (for each...next?). Advise needed about Vlookup loop technique
    By Wino in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2009, 07:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1