The problem only occurs when you insert new rows at the edge of your sum
range. If this bothers you, you could try a different approach to
summing.

Instead of placing =SUM(D3:D25) in D26, replace it with this formula:
=SUM(D3:offset(D26,-1,0))

Then you don't need to change it when new rows are inserted there.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532549