| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding some list items
Hello, I have an easy one here that I cannot seem to figure out. I have a
simple list A:A = Vendor B:B = Amount C:C = Category (from dropdown list) What is the formula to get the sum of only the items in a specific category? E2 to E9 is the list of the categories. I tried =SUMIF(B:B,$E$2=C2) and it comes back as zero when B2=1000 and E2 and C2 are the same. Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding/deleting items from a pivot table dropdown list | Excel Discussion (Misc queries) | |||
| adding a formula to items in a drop down list | Excel Discussion (Misc queries) | |||
| Adding items on an existing drop-down list | Excel Discussion (Misc queries) | |||
| I have a question about adding information to a list of items that have cells linked to another worksheet. | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Threaded Mode
