COUNTIF - Not an Error

D

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, ??????)
 
D

dhstein

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

Peo Sjoblom

If there are no numbers then you can use

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


it will ignore errors


--


Regards,


Peo Sjoblom
 
Top