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

1. Member
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. Member
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. Member
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.

#### Posting Permissions

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