Maintaining Formula after adding a new row

  • Thread starter Thread starter shaught
  • Start date Start date
S

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
 
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!
==============================================
 
Back
Top