Count if greater than 0 returning a divide by zero error

DMPMP

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?

Leibel S

@DMPMP

There is probably a #DIVIDE BY ZERO error somewhere in the [% Paid] column.

DMPMP

Well, that explains it. There were 2, even though it should not have happened in that column. Thanks @Leibel S