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]

Brill! Thanks