Count if greater than 0 returning a divide by zero error

Options

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.

Formula:

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

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

Keeps returning

not sure why. Can anyone help?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!