summing columns

[Walter Donavan]

In a formula of the form =sum(b2:b23) located at b24, if I insert a new row
at b24 so I can add data to the column, the sum formula does not update.

Instead of column b25 changing from =sum(b2:b24), it remains at =sum(b2:b23)
and I have to manually update it. There are a number of columns and I update
them daily, so it's tedious.

There's a solution, right?

Thank you.

 

[Debra Dalgleish]

You could use the following formula instead:

=SUM(OFFSET(B$2,0,0,ROW()-2,1))