I have the following:
A2 = 10
B2 = 10
C2 = 10
D2 = 10
E2 = 10
F2 is =sum(A2:E2) result is 50.
If I insert another column between E & F. The formula moves over and stay's the same range.
I am looking for a formula that sum's the 5 columns to the left of the cell with the formula even if a new column is added. G2 would now contain =sum(B2:F2)
Thanks Kurt
A2 = 10
B2 = 10
C2 = 10
D2 = 10
E2 = 10
F2 is =sum(A2:E2) result is 50.
If I insert another column between E & F. The formula moves over and stay's the same range.
I am looking for a formula that sum's the 5 columns to the left of the cell with the formula even if a new column is added. G2 would now contain =sum(B2:F2)
Thanks Kurt