Enter this formula in F101

=SUM(F2:INDEX(F:F,ROW()-1))

The range will expand/contract as you insert/delete rows above F101


Gord Dibben MS Excel MVP



On Thu, 24 Jan 2008 11:58:04 -0800, bcg wrote:

We have an Excel 2002 spreadsheet where we are using the AutoSum Function to
total an entire column. Currently, the function "=SUM(F2:F99)" is in Cell
F101 and Row 100 is empty. When we inserting a new row into the empty row of
this spreadsheet, the function does not automatically update. "Options:
Calculation" is set to Automatic.

If we change the function to "=SUM(F2:F100)", will that fix the problem? If
not, any other suggestions?

Thanks in advance for the help