Move/Shift Formula from one column to another

[aliikhlaq2006]

Hi,
I have a formula in cell D1 Sum(A1+B1-C1) i want the formula to move forward if if insert a column left side so formula move to the E1 and formula will be Sum(B1+C1-D1). What happens here is that A1 drops out and D1 added in the formula. I try with offset function but not working for me

 

[jasonb75]

formula move to the E1 and formula will be Sum(B1+C1-D1).

What you have asked for is what happens when you insert a column on the left using your existing formula.

 

[aliikhlaq2006]

No i think you not understood it i want the formula to shift forward means drop the A1 and add the new added column

10​	20​	10​		=SUM(A1:C1)	Before
10​	20​	10​	50​	=SUM(B2:D2)	After

 

[aliikhlaq2006]

I think i found a solution thank you for the help. But can you tell me how to add the column to the right side normally columns are added on the left side but is there any way to add to the right side

 

[jasonb75]

No i think you not understood it i want the formula to shift forward means drop the A1 and add the new added column

In post 1 you said you want it to move forward when you 'insert a column on the left' but in post 3 you are adding data to the right side (nothing is being inserted).
This is my interpretation of your requirement based on what little sense I can make of what you're asking. If it is not what you need then a much clearer explanation will be required.

Book1
	A	B	C	D	E	F
1	10	20	10			40
2	10	20	10	50		80
Sheet1

Cell Formulas
Range	Formula
F1:F2	F1	=SUM(INDEX(A1:E1,MATCH(E1+100,A1:E1)-2):E1)