COUNTIF greater than or equal to?
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
Best Answer

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
Answers

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

That did it... Thank you!!!
Help Article Resources
Categories
Check out the Formula Handbook template!