software

Hi,

I have the following partial Values in column quot;Aquot; that I got using
Vlookups. I want to put at the end cell of column quot;Aquot; the quot;SUMquot;
function for the values.

When I tried to do it I get the result quot;#N/Aquot; 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: www.excelforum.com/member.php...foamp;userid=6385
View this thread: www.excelforum.com/showthread...hreadid=538529=SUMIF(A:A,quot;lt;gt;#N/Aquot;)

or fix the vlookups with

=IF(ISNA(VLOOKUP()),quot;quot;,VLOOKUP())

OR

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

If you only need to sum the values

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Portugaquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I have the following partial Values in column quot;Aquot; that I got using
gt; Vlookups. I want to put at the end cell of column quot;Aquot; the quot;SUMquot;
gt; function for the values.
gt;
gt; When I tried to do it I get the result quot;#N/Aquot; where I want the result
gt; to be 60. Is there any way of getting the sum function to take the
gt; number only and disregard the #N/A??
gt;
gt; Thanks
gt;
gt; 10
gt; 10
gt; 10
gt; #N/A
gt; 10
gt; 10
gt; 10
gt; #N/A
gt; ..
gt;
gt;
gt; --
gt; Portuga
gt; ------------------------------------------------------------------------
gt; Portuga's Profile:
gt; www.excelforum.com/member.php...foamp;userid=6385
gt; View this thread: www.excelforum.com/showthread...hreadid=538529
gt;

Brill! Thanks!--
Portuga
------------------------------------------------------------------------
Portuga's Profile: www.excelforum.com/member.php...foamp;userid=6385
View this thread: www.excelforum.com/showthread...hreadid=538529