What you're describing sounds like the ideal situation for using a Dynamic
Range Name. They automatically expand and contract with data additions and
deletions, respectively.

Check Debra Dalgleish's Contextures website for instructions on how to
create and use them:

http://www.contextures.com/xlNames01.html#Dynamic

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Dave" wrote:

Is there a way to make the sum function's range auto update when rows are
added above it. An example would be:

I have the following formula in K20, =SUM(K15:K19). If row 20 is selected
and a new row is inserted, the formula still sums K15:K19. I would like the
formula to update to =SUM(K15:K20) after the row is inserted.

Thanks
Dave