View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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