+ Reply to Thread
Results 1 to 4 of 4

need to sum multiple matches from vlookup

  1. #1
    Registered User
    Join Date
    11-06-2009
    Location
    orlando, fla
    MS-Off Ver
    Excel 2003
    Posts
    2

    need to sum multiple matches from vlookup

    I couldn't find the answer to this in the forums so I'm posting it. I need to do a search for a value in column a and return the value in column d. I tried using vlookup but sometimes there may be multiple matches, if so I need to add them all up and place that value in a cell in a different worksheet. Here is what the data/spreadsheet looks like:

    Worksheet2:
    colA colB colC colD
    /u110 john sunday 100000
    /u123 may tuesday 189376
    /u110 joe saturday 2390000

    So if my search finds /u110 I want it to return both values from colD, add them up and return those results to a cell(A1) in Worksheet1.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: need to sum multiple matches from vlookup

    Maybe you could use a pivot table

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: need to sum multiple matches from vlookup

    =sumif(a1:a3, "\u110", d1:d3)

    or

    =sumproduct( (a1:a3="\u110") * d1:d3)
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    11-06-2009
    Location
    orlando, fla
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: need to sum multiple matches from vlookup

    The sumif was the perfect solution, thanks shg!! The only thing I had to change was the slash in your example was the wrong one. Once I used the backslash it worked like a charm. Thanks for everyone's help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1