COUNTIF - Not an Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dhstein - 29 May 2008 16:00 GMT

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

Reply to this Message

Flower - 29 May 2008 16:54 GMT

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

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

Reply to this Message

dhstein - 29 May 2008 17:14 GMT

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

> I think just count(a1:a5000) will work as it ignores errors?
>
> > 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, ??????)

Reply to this Message

Peo Sjoblom - 29 May 2008 17:30 GMT

If there are no numbers then you can use

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

it will ignore errors

Signature

Regards,

Peo Sjoblom

> Thanks for your response but the entries I have are text and COUNT only
> counts numbers
[quoted text clipped - 7 lines]
>> >
>> > =COUNTIF(A1:A5000, ??????)

Reply to this Message