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


--
shaught
------------------------------------------------------------------------
shaught's Profile: http://www.excelforum.com/member.php...o&userid=30802
View this thread: http://www.excelforum.com/showthread...hreadid=504625

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


"shaught" wrote in
message ...

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


--
shaught
------------------------------------------------------------------------
shaught's Profile:
http://www.excelforum.com/member.php...o&userid=30802
View this thread: http://www.excelforum.com/showthread...hreadid=504625