cell references in excel

[Guest]

I have read that when you insert a row directly above a formula, the row is
not automatically updated in the cell reference, but I was wondering if there
was a way around this. For example, I have a spreadsheet and it calculates
the sum of all the rows above the totals row. When I add a new row directly
above the totals row, it does not include this new row in the totals.
Unfortunately, I have to add the new row directly above the totals row,
because the rows are in birthdate order. Any suggestions???

 

[Don Guillett]

The "easiest" way for you would be leave a blank (hide if you like) to sum
a2:a6. Now when you add a row to the row above the blank (hidden) row, it
will be automatically adjusted.

 

[Guest]

Instead of inserting a blank row, maybe you could copy a row and then "Insert
Copied Rows." Then delete the data in the new row and enter the new data.
This will keep your formulas working.