Add same reference but one column earlier

[ammartino44]

Hello. I have the following formula in a column ='summary ACTUAL'!AL115. The row reference changes throughout the column, but the column reference stays the same. I want to add the same reference but one column before. So it would be summary Actual'!AK115+summary ACTUAL'!AL115. How can I do this with a search and replace or some type of text formula so that I don't have to manually modify the formulas. Again, the row reference will be the same, but I just want to add the column reference. Does this make sense? Spreadsheet attached.

[Moo the Dog]

Can't you just change the formula to something like:

=SUM(Sheet2!A3:B3)

then fill it down?

- Moo

[ammartino44]

No, because the rows change. For example, in Row 1 I might reference row 6, in Row 2, I might reference Row 7 (in the other sheet).