how to sum multiple matches to a vlookup command
Try
=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.
Mike
"LoganTaylin" wrote:
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
|