# excel auto sum question and other

#### Michele Bishop

##### New Member
We have a spreadsheet created and the boss wants the totals to be the top row. I am having issues with Auto Sum as every time I add a new row, I then have to update the formula to include that new row. I am sure there is an easier way to do this but I have been unable to find. Any help would greatly be appreciated.

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

#### VoG

##### Legend
Hello and welcome to MrExcel.

You can use a formula like

=SUM(C2:C1000)

Excel will ignore any blank rows below your data.

#### Michele Bishop

##### New Member
I tried that - at least I thought I did. But when I enter a new row at the top (boss wants most current info entered on top) the formula changes to SUM=C3:C1000. If I entered a new row at the bottom, I do not have the issue. Hope that makes sense.

##### Well-known Member
Excel Workbook
IJ
1TOTAL842
210
325
435
5100
674
764
861
958
1055
1152
1249
1346
1443
1540
1635
1735
1835
1925
Sheet1

Don't use the Autosum, just type and highlight the cells you want to include

#### Michele Bishop

##### New Member
So I have to redo the formula each time to include the new row? The new row would replace the current row 2. When adding now, it does not included in the total formula in row 1. To note - there are 30 columns that I have to update each time which is why I had hoped there was an easier way.

#### xlHammer

##### Board Regular
Try something like;

=SUM(OFFSET(C\$1:C1000,1,0))

##### Well-known Member
Does your totals have to be at the top of the row your summing? you could put in A;1 =Sum(B:B) and that will update even if you put a new row in. other than that you would maybe get away with it if you made the row you were summing into a dynamic range which would also allow new rows to be added

Replies
2
Views
336
Replies
2
Views
774
Replies
7
Views
306
Replies
0
Views
119
Replies
2
Views
300

1,191,683
Messages
5,987,991
Members
440,124
Latest member
dippy_egg

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