add numbers with corresponding products
 

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?

add numbers with corresponding products
 

=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)



"jenn" wrote in message
...
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?

add numbers with corresponding products
 

=SUBTOTAL(9,A1:A100)


"jenn" wrote:

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?