Ignoring #N/A in an Autosum range

[Jaye]

I need to be able to add data in a column, and some of the cells in that
column have an #N/A in it, resulting from a VLOOKUP. How do I add the data in
the column, and have it ignore the #N/A?

[Ron Coderre]

Try something like this:

For values in A1:A10

B1: =SUMIF(A1:A10,"<>#N/A",A1:A10)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jaye" wrote:

> I need to be able to add data in a column, and some of the cells in that
> column have an #N/A in it, resulting from a VLOOKUP. How do I add the data in
> the column, and have it ignore the #N/A?

[Jaye]

Awesome - worked perfectly!! Thanks so much.

Another question - if I do a VLOOKUP and the resulting answer is the #N/A
again, how can I get the result to be a zero (0)?

"Ron Coderre" wrote:

> Try something like this:
>
> For values in A1:A10
>
> B1: =SUMIF(A1:A10,"<>#N/A",A1:A10)
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
> XL2002, WinXP-Pro
>
>
> "Jaye" wrote:
>
> > I need to be able to add data in a column, and some of the cells in that
> > column have an #N/A in it, resulting from a VLOOKUP. How do I add the data in
> > the column, and have it ignore the #N/A?

[Biff]

See your other post.

Biff

"Jaye" <[email protected]> wrote in message
news:[email protected]...
> Awesome - worked perfectly!! Thanks so much.
>
> Another question - if I do a VLOOKUP and the resulting answer is the #N/A
> again, how can I get the result to be a zero (0)?
>
> "Ron Coderre" wrote:
>
>> Try something like this:
>>
>> For values in A1:A10
>>
>> B1: =SUMIF(A1:A10,"<>#N/A",A1:A10)
>>
>> Does that help?
>>
>> ***********
>> Regards,
>> Ron
>>
>> XL2002, WinXP-Pro
>>
>>
>> "Jaye" wrote:
>>
>> > I need to be able to add data in a column, and some of the cells in
>> > that
>> > column have an #N/A in it, resulting from a VLOOKUP. How do I add the
>> > data in
>> > the column, and have it ignore the #N/A?