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