=COUNTIF(A2:CY5000,#REF!)

HTH
--
AP

"Bob" a écrit dans le message de news:
...
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