View Single Post
  #1   Report Post  
Sanjeev Unnikrishnan
 
Posts: n/a
Default 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