Auto Sum Function

  • Thread starter Thread starter bcg
  • Start date Start date
B

bcg

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
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Function in Excel 2003 2
Sum if Critea 1 and critera 2 are met 6
IF formula, Partial word, SUM function as result 1
Autogroup then sum - can it be done? 5
How do I autosum a filtered column 1
Dynamically sum rows 3
autosum refusal to sum highlighted range 4
Sum function changes arguments 1

Back
Top