If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|