Sum

  • Thread starter Thread starter sgrech
  • Start date Start date
S

sgrech

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'
appear to like the #N/A.

Any suggestion would be gratefully received.

Thanks
Simo
 
sgrech said:
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
Click to expand...

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")
 
Back
Top