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

[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?

 

[bpeltzer]

Try sumif rather than vlookup... =sumif($a$1:$a$3,d1,$b$1:$b$3).

 

[smartin]

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?

VLOOKUP will only return a single value in column B. You want the sum of
all values in column B based on your criteria.

This will do what you ask, but I'm not sure if what's you want. Put this
in E1 and fill down.

=SUMIF($A:$A,$A1,$B:$B)

 

[Keith]

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!