Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if and sumif
I am putting together a budget spreadsheet and would like to have one
expense tracking spreadsheet. In my budget sheet I want to run check two pieces of data in the expense sheet. I want to check the month and the category of an expense then pull it over into the budget sheet. I am currently using the sumif function to call by category but I also want to check the month. My goal is to have a budget tab for each month and one expense tab in order to do this I need to get the sum of the information based on the month column and the category column. Ie I need all the food expenses for July. Thanks for the help, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |