Maintaining Formula after adding a new row

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shaught - 24 Jan 2006 20:40 GMT

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

Reply to this Message

RagDyer - 24 Jan 2006 21:05 GMT

Funny, I get:

=SUM(A6:A11)

Nevertheless, try this:

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

Signature

HTH,

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

> 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.

Reply to this Message