Formula changes while inserting a row !!!!

[Sanjeev Unnikrishnan]

Hi,

My worksheet looks like this.
In A2 = 3
In A3 = 4
In A1 = Sum(A2:A3)

If I insert a row in between A1 and A2, the formula in A1 changes to
"=sum(A3:A4)", whereas I want it to show, "=sum(A2:A4)".

How can I do this ???

Regards,
Joseph

 

[Domenic]

Try...

=SUM(INDIRECT("A2"):A3)

Hope this helps!

 

[Don Guillett]

try this
=SUM(INDIRECT("A2:A"&ROW(A3)))

 

[Sanjeev Unnikrishnan]

Thanks !!! It works !!!

Try...

=SUM(INDIRECT("A2"):A3)

Hope this helps!