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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!