Results 1 to 3 of 3

Thread: Sum up a number of matches in Vlookup in Excel

  1. #1
    Join Date
    Feb 2012
    Posts
    10

    Sum up a number of matches in Vlookup in Excel

    I need to run a vlookup for an exact value in a range and for each match calculate the total of the cell adjacent. For example, James appears in this list twice and I want to reach a sum of his sales listed. I know I can do a vlookup command, but I'm not sure what to do when there are multiple matches. Thanks.
    Name Sales Name Total Sales
    • James $120 James
    • Bob $168 Bob
    • Randy $65 Randy
    • James $54 Henry
    • Henry $796 Pete
    • Pete $164 Alfred
    • Bob $638
    • Alfred $945
    • Randy $12
    • Henry $578
    • Alfred $324
    • Pete $179

  2. #2
    Join Date
    May 2011
    Posts
    526

    Re: Sum up a number of matches in Vlookup in Excel

    Try the following : =SUMPRODUCT((A2:A13="James")*(B2:B13)) you may also get away with =SUMPRODUCT(($A$2:$A$13=A2)*($B$2:$B$13)) and drag down.

  3. #3
    Join Date
    May 2011
    Posts
    410

    Re: Sum up a number of matches in Vlookup in Excel

    You can get by with SUMIF. In E1, copied down: =SUMIF(A:A,D1,B:B) where the unique names are listed in D1 down.

Similar Threads

  1. Need help to get rid of #n/a error in Excel Vlookup
    By Culpritism in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 06:39 PM
  2. Getting multiple matches result on Vlookup sum
    By TheCarter in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 01:08 PM
  3. How to get yes or no in Vlookup in Excel
    By Gurmeet in forum MS Office Support
    Replies: 2
    Last Post: 24-01-2012, 03:57 PM
  4. Multiple Matches Return To VLOOKUP
    By Brunon in forum Windows Software
    Replies: 5
    Last Post: 26-11-2010, 10:32 PM
  5. Number stored as text in vlookup
    By Alexander102 in forum Windows Software
    Replies: 3
    Last Post: 09-06-2009, 09:00 AM

Posting Permissions

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