how do i use vlookup and add all the results in pulls?

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I want to be able to look up all occurances in column A for 1000 and add the
corresponding results in column B. So that column E will show the results for
product "1000".

A B D E
1 1000 5 1000 = 7
2 3000 6 2000 = 0
3 1000 2 3000 = 6

Do I use VLOOKUP? How do I get it to add the results from column B?
 
Thanks "bpeltzer" & "smartin". A buddy of mine told me the exact same thing.
=) I have no idea what I was thinking. I knew about sumif but I was, for
whatever reason, thinking that sumif was restricted to only one column.
So THANKS AGAIN!
 
Back
Top