Excel automatically does this as long as you insert a new data inside the sum
range. Instead of inserting new data at row 101 insert the new row at row
100. then copy the data at row 101 to 100 and add the new data at row 101
like this

Before
99 55
100 26
101 sum(A70:A100)

After Insert Row
99 55
100
101 26
102 sum(A70:A101)

Then copy from 101 to 100
99 55
100 26
101
102 sum(A70:A101)

Add new Data
99 55
100 26
101 44
102 sum(A70:A101)


If you need to add in the middle of the table then just add a row and you
don't need to copy anything



"Soulscream" wrote:

I have a spread sheet that is laid out in sections grouped by dates. I am
trying to create a function that will sum a particular column correctly and
expand even when new information is added and the dates are resorted.

Example: Cell C100 should sum the column A80:A99, but when new information
is added and then the spread sheet is resorted the column will expand to
A80:A100 in which case Cell C101 would then properly total A80:A100 and Cell
C100 would go back to being blank.

I think there may be a way to count between blank cells and on my
spreadsheet Cell A79 will always be blank, and whatever cell in the A column
of the same row as my C cell with my formula (ie. A100 or A101) will always
be blank.

If anyone has any ideas your help would be greatly appreciated.
Thank you.