Sumifs

[Business_Sheardie]

Hi All,

I'm missing a trick or something over my Sumifs function. I am simply trying to sum up monthly income based on dates. I presume I am using the right function. I've checked my dates are formatted as dates. So what silly thing am I doing wrong?

[#2]

@Business_Sheardie 

=SUMIFS($B$2:$B$4,$A$2:$A$4,">="&E3,$A$2:$A$4,"<="&F3)

Is this what you want to do? 

[#3]

Thanks so much. I understand why you have applied absolute referencing now. What is the purpose of the & before the cells E3 and E4? I try the formula wizard to make things easier but didn't use the & and guess this was the error. Appreciate your reply.

[#4]

@Business_Sheardie 

The ampersand is there because it must be used to join the inequality sign with the cell reference. When the cell reference is in quotes it's evaluated as literal text.

Here's a similar example with COUNTIF. The function arguments menu shows how Excel evaluates each.  In the second picture we see the serial number for the date.