View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default how to sum multiple matches to a vlookup command

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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