David,
Thanks for the suggestion.
I tried the following formula:
=COUNTIF(A2:CY5000,ERROR.TYPE(A2:CY5000)=7)
But the result is still zero (it should be 2).
Am I doing something wrong?
Thanks again for your help,
Bob

P.S. I need to test for other error types besides #N/A. Hence, the reason
why using ISNA() is not an option here.



"David Biddulph" wrote:

Try the ISNA() function, and also ERROR.TYPE().

Your formula is looking for a text string "#N/A".
--
David Biddulph

"Bob" wrote in message
...
The following formula finds the number of errors on the worksheet:
=SUMPRODUCT(--(ISERROR(A2:CY5000)))
=4

Now I'm trying to determine which errors were found, so I wrote the
following formula:
=COUNTIF(A2:CY5000,"#N/A")
=0

After manually looking through the entire worksheet I found 2 cells
containing "#N/A". Yet, my previous formula returned zero.

Is there a way I can find a specific error type (e.g., #N/A, #VALUE!,
#REF!,
etc.)? If so, I would appreciate any help in coming up with the correct
formula.

Thanks,
Bob