Bob,

You have wrote the right formula. It must return u the right result. U can
check case sensetive like "#n/a" instead of "#N/A" without any space. I have
tried this function and that returned my your desired result: -

I repeat: =COUNTIF(A2:CY5000,"#N/A")

Mujeeb

"Bob" wrote:

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