| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif-add amount to another cell based on two criteria
I have a list of expense categories and the months of the year across top.
At the very top one drop-down cell with list of expense categories and another with drop-down list of Months. Third cell is amount from receipt to be inputed and added to appropiate category and month. would sumif work or am i looking at the wrong formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Based on one cell criteria to change the rest of that row to a col | Excel Discussion (Misc queries) | |||
| count cell if value present in every other cell + criteria | Excel Worksheet Functions | |||
| How do you reference another cell in the criteria of a SUMIF funct | Excel Worksheet Functions | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
Linear Mode
