SUMIFS formula including less than or equals criteria

Hi there

I am trying to use the following formula [=SUMIFS(E:E,I:I,$D15,F:F,>=$C$5)] to say 'sum column E if column I equals cell $D$15 and column F is equal or less than cell $C$5.'

The formula seems to be spitting the dummy because of the less than and equals criteria.

Can anybody help?

Cheers

you need to put >= in inverted commas followed by &
here is what i mean

[=SUMIFS(E:E,I:I,$D15,F:F,">="&$C$5)]

A simpler way to indicate "greater/less than or equal to" is to remove the equals sign altogether. For example, rather than ">=6" (which probably won't work), just use ">5".

Thanks guys

smb_146 that works perfectly. Thank you

you are welcome dear

Hello,

Not sure anyone will see my note or not as this is 2014's thread. My problem is similar to this. This why I am not creating a new thread.

To sumup data, I am using $E:$E,"<="&$G25 formula in SUMIFS. but problem, this the formula is not considering last day of a month. There are aroung 500 particulars that matches and sumifs is working fine except the date 1/31/2020. I itried to change date to 1/30/2020, formula is working fine.

Then I have added +1 at the and of the formula which is $E:$E,"<="&$G25+1 and formula is calculating all the data. Is that correct way to solve the issue?

Thank you.
Rinko.