Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Products | Excel Worksheet Functions | |||
deleting products | Excel Discussion (Misc queries) | |||
Products | Excel Worksheet Functions | |||
Sum the products of a formulas | Excel Discussion (Misc queries) | |||
better/faster way than sum products? | Excel Worksheet Functions |