COUNTIF - Not an Error

[dhstein]

Is there a way to use Countif to count the number of cells in the range that
are not errors - in other words - they are NOT #VALUE and NOT #DIV 0 etc.

=COUNTIF(A1:A5000, ??????)

 

[Flower]

I think just count(a1:a5000) will work as it ignores errors?

 

[dhstein]

Thanks for your response but the entries I have are text and COUNT only
counts numbers

 

[Peo Sjoblom]

If there are no numbers then you can use

=COUNTIF(A2:A200,">=99^99")


it will ignore errors


--


Regards,


Peo Sjoblom