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