COUNTIF - Not an Error
 

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

COUNTIF - Not an Error
 

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



"dhstein" wrote:

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

COUNTIF - Not an Error
 

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

"Flower" wrote:

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



"dhstein" wrote:

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

COUNTIF - Not an Error
 

If there are no numbers then you can use

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


it will ignore errors


--


Regards,


Peo Sjoblom


"dhstein" wrote in message
...
Thanks for your response but the entries I have are text and COUNT only
counts numbers

"Flower" wrote:

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



"dhstein" wrote:

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