Max - That did the trick! Thanks!
Bob
"Max" wrote:
One way is to try it as:
=SUMPRODUCT(--(ISERROR(A1:DG5000)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bob" wrote:
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.