Count if greater than 0 returning a divide by zero error


Hello everyone,

I am trying to count in a sheet the number of items greater than 0 and it is suddenly giving me a divide by zero error. This formula had been working but is now broken. Help, please.


=COUNTIF([% Paid]:[% Paid],

Also tried =COUNTIF([% Paid]:[% Paid], ">0")

Keeps returning

not sure why. Can anyone help?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!