Sum

Hi,

I have a following data in a column on my spreadsheet

0.00
-98.35
#N/A
-222.89
56.45
0.00
13.60
19.96

When trying to use the Sum function it doesn't work as it doesn't
appear to like the #N/A.

Any suggestion would be gratefully received.

Thanks
Simon


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

sgrech wrote:
Hi,

I have a following data in a column on my spreadsheet

0.00
-98.35
#N/A
-222.89
56.45
0.00
13.60
19.96

When trying to use the Sum function it doesn't work as it doesn't
appear to like the #N/A.

Any suggestion would be gratefully received.

Thanks
Simon

You have to modify the cell with the #N/A (probably using an IF statement)
so that it doesn't return #N/A but 0 or a blank.

Hi
one way: prevent the #NA errors with a formula like
=IF(ISNA(your_formula),"",your_formula)

or use
=SUMIF(A1:A100,"#NA")

--
Regards
Frank Kabel
Frankfurt, Germany

"sgrech" schrieb im Newsbeitrag
...

Hi,

I have a following data in a column on my spreadsheet

0.00
-98.35
#N/A
-222.89
56.45
0.00
13.60
19.96

When trying to use the Sum function it doesn't work as it doesn't
appear to like the #N/A.

Any suggestion would be gratefully received.

Thanks
Simon


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