Make AutoSum Cell move down as rows are populated?

Just cover the unused range in your sum function, since you will not be adding the any new rows

Or

We can use some other function to read the data and do the summing based on the last entry but a sample file will be helpful for giving exact solution

hi poof. couple of ways. assuming data in A1:A10. in Excel 2003, you can select the data you have & press CTRL + L. the sum range will change as rows are added directly below.

you can also create dynamic ranges. this is assuming there are no other data below A11, A1 is the header.
=SUM(A2:INDEX(A:A,COUNTA(A:A)))

or:
=SUM(OFFSET($A$2,,,COUNTA(A:A)-1))

if you cant do it, Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Or make the sum above the column, than there is no problem if you add an row to your data.

2e advantance if you use freese panes you also have the sum always on your screen

3e advantance if you want to print the data you can have the sum on multiple pages.

Thanks for the feedback.

Glad I could help.

Will you mark, your question solved (is it's solved) and you not done it already.