Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct from a drop down list
I have a column with a drop down list:
Condo Multi-Family Retail - Ready Retail - Land SF Lots Industrial Mixed Use Land I need a formula when one of the drop downs is selected, it will total all the dollars associated with each selection. I have tried the following formula: =SUMPRODUCT(--D6:D18,"Multi-Family",SUM(E6:P18)) This gives an answer of #VALUE! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
Drop Down List | Excel Worksheet Functions |