Forum Discussion
Help with a sumif formula
Hi
I am looking to make a budget spreadsheet that lets me see when money has been spent but is also committed. I have managed to get a Sumif column to work out if money has been allocated within a certain time but I would like it to do more if possible. I cannot seem to get a formula that works so any advice would be welcome.
Basically, I want it to do two things in the committed spend box:
1- check if the money has been committed within the year e.g. 1/04/19 -31/03/20,
2- then check if it has been paid out by looking at the paid column.
3 Replies
Of course I agree with the final touch of SergeiBaklan :)
I was just focusing on the use of comparison operators in the SUMIFS function.
thank you my friend!Hi
You have some issues with the SUMIFS functions when using a comparison operator.
You need to:
- Include the comparison Operator in Double quotations
- Add a Joining operator between it and the date "&"
- No double quotations around the date
example
=SUMIFS($F$2:$F$17,$H$2:$H$17,">="&1-3-2019,$H$2:$H$17,"<="&31-3-2020)
Hope that helps
Nabil Mourad
nabilmourad , I'd use DATE() instead of constant not to depend on locale, like
DATE(2019,3,1)
