What does ISERROR look at besides the 7 Error Types?

[Guest]

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.

 

[Guest]

ISERROR function is cover all kind the errors

 

[Guest]

Like what?

ISERROR function is cover all kind the errors

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.

 

[Guest]

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

Like what?

ISERROR function is cover all kind the errors

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.

 

[Guest]

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)))

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

Like what?

ISERROR function is cover all kind the errors


:

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.

 

[Chip Pearson]

Those are the only errors I know of, and those are only values defined in
XLCVErr. You could try scanning the cells and see what turns up.

Sub AAA()
Dim V As Variant
Dim Rng As Range
For Each Rng In ActiveSheet.UsedRange.Cells
V = Rng.Value
If IsError(V) = True Then
Select Case V
Case CVErr(xlErrNA), CVErr(xlErrName), _
CVErr(xlErrDiv0), CVErr(xlErrNull), _
CVErr(xlErrRef), CVErr(xlErrNum), _
CVErr(xlErrValue)
' expected errors
Case Else
MsgBox "OTHER ERROR: " & Rng.Address & " " & CStr(V)
End Select
End If
Next Rng
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)