Try...

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

Hope this helps!

In article ,
"Sanjeev Unnikrishnan"
wrote:

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