Depends how you set it up.

If you have the totals on row 1, ie =SUM(A2:A100) and when adding a row
put the cursor on row 2 and select Insert a row the formula will change
automatically to allow for the new line.

You could equally have the totals on say row 101 but theyll keep moving
down the spreadsheet as you add a row then you gotta navigate down to
the totals.

Or store the totals on a different spreadsheet


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562502