Help with a sumif formula

[Gemma Telfer]

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.

[#2]

@Gemma Telfer 

Hi

You have some issues with the SUMIFS functions when using a comparison operator.

You need to:

1. Include the comparison Operator in Double quotations
2. Add a Joining operator between it and the date "&"
3. 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

[#3]

@nabilmourad , I'd use DATE() instead of constant not to depend on locale, like

DATE(2019,3,1)

[#4]

@Gemma Telfer 

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!