COUNTIF greater than or equal to?

LeAndre P

Hello,

I am trying to find the number of entries that are greater than 0 but are equal to or less than 2. Many of the results in the data source column are in decimal form. for example 1.38 etc. The formula I have now either does not recognize the decimal result or I get an #UNPARSEABLE error. I seem to be missing something because the formula isn't working.

Formula —

=COUNTIF([Warranty remaining]:[Warranty remaining]), >= 2)

Thanks in advance

Kelly Moore

Hey @LeAndre P

There is an extra parenthesis in the above formula.

Try this

=COUNTIFS([Warranty remaining]:[Warranty remaining], AND(@cell>0, @cell<=2))

cheers

Kelly Moore

Hey @LeAndre P

There is an extra parenthesis in the above formula.

Try this

=COUNTIFS([Warranty remaining]:[Warranty remaining], AND(@cell>0, @cell<=2))

cheers

LeAndre P

That did it... Thank you!!!