Yes, I know (refer to my original message). What I am trying to ascertain is
what other errors (besides #N/A,#VALUE!,#REF!,#DIV/0!,#NUM!,#NAME?, and
#NULL) is ISERROR capturing when used the formula:
=SUMPRODUCT(--(ISERROR(A2:CY5000)))


"Teethless mama" wrote:

ISSERROR returns TRUE if value is any error
value(#N/A,#VALUE!,#REF!,#DIV/0!,#NUM!,#NAME?, or #NULL)

"Bob" wrote:

Like what?


"Teethless mama" wrote:

ISERROR function is cover all kind the errors


"Bob" wrote:

I have a formula [=SUMPRODUCT(--(ISERROR(A2:CY5000)))] in my worksheet that
tells me that I have 24 "errors". After accounting for all the cells that
have either #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! in them,
I'm still left with 8.
Can anyone tell me what the 8 other "errors" may be?
Thanks.