Sum function
 

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

Sum function
 

=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" wrote in
message ...

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

Sum function
 

Brill! Thanks!


--
Portuga
------------------------------------------------------------------------
Portuga's Profile: http://www.excelforum.com/member.php...fo&userid=6385
View this thread: http://www.excelforum.com/showthread...hreadid=538529