I'm trying to determine which error types exist in a fairly large worksheet,
so I wrote the following formula to find the number of "#REF!" errors:

=COUNTIF(A2:CY5000,ERROR.TYPE(A2:CY5000)=4)

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

Can someone tell me why my formula isn't working correctly?
Thanks,
Bob