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