Counting the number of errors in a worksheet

B

Bob

I have a worksheet containing formulas in the range of A1:DG5000. I wrote
the following formula to count the number of (any) errors in that range:

=COUNT(ISERROR(A1:DG5000))

I know there are 4 cells containing errors, but the aforementioned formula
returns a value of 1.
Any help would be greatly appreciated. Thanks.
 
D

Dave Peterson

How about:

=SUMPRODUCT(--(ISERROR(A1:dg5000)))


I have a worksheet containing formulas in the range of A1:DG5000. I wrote
the following formula to count the number of (any) errors in that range:

=COUNT(ISERROR(A1:DG5000))

I know there are 4 cells containing errors, but the aforementioned formula
returns a value of 1.
Any help would be greatly appreciated. Thanks.
Click to expand...
 
A

ArcticWolf

Thanks for this answer Max - it's helped me out aswell.

Can I just ask though, what does the -- mean inbetween the two brackets ie
(--( and how does it affect the formula?

Thanks,

AW
 
Top