Counting the number of errors in a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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...
 
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
 
Back
Top