COUNTIF greater than or equal to?


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!