Re: How do you work around the #N/A error?

Hi,

In your summing formula use something like this:

=SUM(IF(ISNA(A1:A100),0,A1:A100))

Confirm with control-shift-enter, since this is an array
formula.

Regards,

Jan Karel Pieterse
Excel TA/MVP

>-----Original Message-----
>I am trying to sum three cells of numbers. Each cell's
>value is the result of a Vlookup and, in some cases, the
>Lookup Value does not exist. If the Value does not exist
I
>would like to add a zero to my sum instead. All of my
>efforts to add an error check have failed. Any IF
>statement I use checking such "IF(ISNA(A1)="TRUE",0,A1)"
>or "IF(A1="#N/A",0,A1)" have returned circular reference
>errors. I do not want approximate values returned so I'm
>using Range Lookup=FALSE. There must be some way around
>this problem but I have no idea what it is. Any help you
>can offer would be greatly appreciated. Thanks.
>.
>