Formula changes while inserting a row !!!!
 

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

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

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

--
Don Guillett
SalesAid Software

"Sanjeev Unnikrishnan" wrote
in message ...
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

Thanks !!! It works !!!

"Domenic" wrote:

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