# Sums with negative numbers

#### amfroehlich

##### Board Regular
=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?

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Nope - should just add them up as they are (though obviously adding a minus decrements the total not increases it.

...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.

Replies
8
Views
239
Replies
8
Views
220
Replies
1
Views
250
Replies
5
Views
333
Replies
1
Views
518

1,203,082
Messages
6,053,420
Members
444,662
Latest member
AaronPMH

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back