add numbers with corresponding products

[jenn]

im trying to get a drop down list and add number in another column, when i
use autosum the numbers add up right, but when i chose one product to check
the numbers, they dont change. the total shown is for all products, how do i
get a total for each individual products in the drop down list?

 

[Bob Phillips]

=SUMIF(B:B,product_cell,A:A)

with relevant rages of course

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Teethless mama]

=SUBTOTAL(9,A1:A100)