Sums with negative numbers

[amfroehlich]

=Sum(i8:i150)

returns that last number because most of them are negative. Is their anything speical that you have to do to sum a negative number?

 

[macleanb]

Nope - should just add them up as they are (though obviously adding a minus decrements the total not increases it.

 

[Oaktree]

...Or do you mean that you want 1 + (5) + 10 = 16 (ignoring the sign of each number)?

If so, try =Sum(abs(i8:i150)), confirmed with CTRL+SHIFT+ENTER instead of just enter.