Forum Discussion

Gemma Telfer's avatar
Gemma Telfer
Copper Contributor
Jul 05, 2019

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 ...
excel
Formulas and Functions
sumif
nabilmourad's avatar
nabilmourad
MVP
Jul 05, 2019

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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 05, 2019

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

DATE(2019,3,1)

Resources