I'm trying to create my own expense/budget spreadsheet, but I'm having trouble with a formula, as I'm not expert.
So, basically I have one sheet where I input my expenses. In that sheet are columns date, total, category
The date is in the format dd/mm/yy
The total is currency, two-digit
the category is a drop-down list that I have made.
On another sheet I have my budget which tracks the expenses against the budget. What I want is to be able to enter the expense, date and category and the total amount of that category, for that month to be automatically added and entered into the budget sheet.
Currently I have this formula, which gives me the totals for the category, but doesn't use the second criteria I want, the date. I could make a seperate sheet for each month, but I think having two criteria (date and category) is cleaner.
Here is an example:
=SUMIF(INDIRECT("Spending!G2:G1000"),"Dining Out",INDIRECT("Spending!D2:D1000"))
So as you can tell, the "expense sheet" is called Spending
The column containing the dates is A
The column containing the expense is D
The column containing the category is G
From what I've read, it's hard (if not impossible?) to use two criteria with the SUMIF function. I understand the SUMPRODUCT is what I should be using but I can't for the life of me get the syntax correct...
Anyone able to help a function-illiterate guy out?
So, basically I have one sheet where I input my expenses. In that sheet are columns date, total, category
The date is in the format dd/mm/yy
The total is currency, two-digit
the category is a drop-down list that I have made.
On another sheet I have my budget which tracks the expenses against the budget. What I want is to be able to enter the expense, date and category and the total amount of that category, for that month to be automatically added and entered into the budget sheet.
Currently I have this formula, which gives me the totals for the category, but doesn't use the second criteria I want, the date. I could make a seperate sheet for each month, but I think having two criteria (date and category) is cleaner.
Here is an example:
=SUMIF(INDIRECT("Spending!G2:G1000"),"Dining Out",INDIRECT("Spending!D2:D1000"))
So as you can tell, the "expense sheet" is called Spending
The column containing the dates is A
The column containing the expense is D
The column containing the category is G
From what I've read, it's hard (if not impossible?) to use two criteria with the SUMIF function. I understand the SUMPRODUCT is what I should be using but I can't for the life of me get the syntax correct...
Anyone able to help a function-illiterate guy out?