Jul 05 2019 05:29 AM
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.
Jul 05 2019 07:33 AM
Hi
You have some issues with the SUMIFS functions when using a comparison operator.
You need to:
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
Jul 05 2019 02:17 PM
@nabilmourad , I'd use DATE() instead of constant not to depend on locale, like
DATE(2019,3,1)
Jul 05 2019 02:44 PM - edited Jul 05 2019 02:47 PM
Of course I agree with the final touch of @Sergei Baklan :)
I was just focusing on the use of comparison operators in the SUMIFS function.
thank you my friend!