Maintaining Formula after adding a new row

[shaught]

I have a formula that adds data in a column. =SUM(A5:A10). The proble
is that every time I copy a new row and insert it at row 5, my formul
changes to =SUM(*A6*:A10). I just want it to stay the same. I'v
tried using an absolute value $A$5, but it still changes when a new ro
is added. I've tried using a named reference as well as locking, but m
merged cells caused some problems with the lock

 

[RagDyer]

Funny, I get:

=SUM(A6:A11)

Nevertheless, try this:

=SUM(INDIRECT("A5:A10"))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================