SUMIFS won't work with >= as a criteria

**JYonker** · 11-19-2010, 05:06 PM

Hi,

I am trying to do the following SUMIFS and it won't work because of the >=. I have tried putting it in quotes and even using a cell refrence. Any help would be great. Thanks!

=SUMIFS('DATA TAB'!$AT:$AT,'DATA TAB'!$D:$D,Unclaimed!$J16,'DATA TAB'!$D:$D,"",'DATA TAB'!$BH:$BH,">7")

**rgi** · 11-19-2010, 05:17 PM

The function is missing a single cell for criteria1. Fix that first. SumIFS is tricky in that it alternates between range and criteria. When using the function wizard I have often forgot to tab out of the criteria field and accidentally input Range2.

**daddylonglegs** · 11-19-2010, 05:21 PM

Hello JYonker,

I don't see >= in your formula where should that go? Also you have two conditions for column D, do you want the sum if either of those is true?

**JYonker** · 11-19-2010, 06:04 PM

Sorry,

This is the formula, I posted an old one.

=SUMIFS('DATA TAB'!$AT:$AT,'DATA TAB'!$D:$D,Unclaimed!$I4,'DATA TAB'!$J:$J,"",'DATA TAB'!$BH:$BH,"<=7")

Also, in this specific case, when I say "<=7" I am not looking for number less then 7, just wanting to sum the tag"<=7"...
That leads me to another question I have... Is there a way to incorporate number below something or whithin a certain range in a sumifs?

Thank you everyone. I really do appreciate it.

Jasper

**daddylonglegs** · 11-19-2010, 06:12 PM

Jasper,

the problem is that "<=7" is only summing values less than or equal to seven, if you want to sum where string is <=7 add another =, i.e. criterion should be

"=<=7"