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