SUM #n/a
 

Hi,
I wonder if somebody can help with this. I need to sum a number of
cells, however some of these cells may contain #n/a. The sum function
doesn't like these values, can some suggest a suitable way to get
around this?/

Thanks
Simon


--
sgrech
------------------------------------------------------------------------
sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501
View this thread: http://www.excelforum.com/showthread...hreadid=466618

Try something like this:
=SUMIF(A1:A10,"<#N/A",A1:A10)

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=466618

Yes thanks that works.

Cheers


--
sgrech
------------------------------------------------------------------------
sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501
View this thread: http://www.excelforum.com/showthread...hreadid=466618