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