Sum function

Giganews Newsgroups
Subject: Sum function
Posted by:  Portuga (Portuga.278q0o_1146674401.9212@excelforum-nospam.com)
Date: Wed, 3 May 2006

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?action=getinfo&userid=6385
View this thread:http://www.excelforum.com/showthread.php?threadid=538529

Replies