View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Only if you insert the column to the left of F4 will it do that
btw, no need for a SUM formula, =I4-F4 will do

Regards,

Peo Sjoblom

"Charlie" wrote:

I have a cell formula =SUM(I4,-F4) which is in cell J4. If I insert a
column so that j moves to k, I want the formula to adjust to
=SUM(J4,-G4). Is this possible, and if so how?
thanks...charlie