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

bcg,

If you insert a row before row 99, your formula will update. If you insert
it after, the formula will not.

HTH,


Conan





"bcg" wrote in message
...
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

The formula will adjust itself only if the new row is inserted before the
last row and after the first row used in the formula.

changing the function to =SUM(F2:F100) should fix the problem. Try it.

"bcg" wrote in message
...
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

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