Auto Sum Function

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
 
C

Conan Kelly

bcg,

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

HTH,


Conan
 
G

Gaurav

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

Gord Dibben

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

Sum if Critea 1 and critera 2 are met 6
Auto Sum 0
An Odd problem with SUM using : 0
Autogroup then sum - can it be done? 5
Auto Sum not working correctly 1
Help with lots of formulas 3
Sum function changes arguments 1
Sum Function When Formula Produces #N/A 2

Top