Sum function

[Portuga]

Hi,

I have the following partial Values in column "A" that I got using Vlookups. I want to put at the end cell of column "A" the "SUM" function for the values.

When I tried to do it I get the result "#N/A" where I want the result to be 60. Is there any way of getting the sum function to take the number only and disregard the #N/A??

Thanks

10
10
10
#N/A
10
10
10
#N/A
...

[Peo Sjoblom]

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

or fix the vlookups with

=IF(ISNA(VLOOKUP()),"",VLOOKUP())

OR

=IF(ISNA(VLOOKUP()),0,VLOOKUP())

If you only need to sum the values

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Portuga" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I have the following partial Values in column "A" that I got using
> Vlookups. I want to put at the end cell of column "A" the "SUM"
> function for the values.
>
> When I tried to do it I get the result "#N/A" where I want the result
> to be 60. Is there any way of getting the sum function to take the
> number only and disregard the #N/A??
>
> Thanks
>
> 10
> 10
> 10
> #N/A
> 10
> 10
> 10
> #N/A
> ..
>
>
> --
> Portuga
> ------------------------------------------------------------------------
> Portuga's Profile:
> http://www.excelforum.com/member.php...fo&userid=6385
> View this thread: http://www.excelforum.com/showthread...hreadid=538529
>

[Portuga]

Brill! Thanks!