I have many formulas (20+) using data from some range in a single spreadsheet.

The problem is that when I copy those formulas to some other part of the spreadsheet to handle another range, I have to manually modify each of them to adapt them with the new range value !!

What I'm looking for is -for example- to enter the range value in one cell as a string, so all my formulas will automatically use that string value as a range.

In other words, let's say that my formula in cell `A2`

is calculating the sum of a range using `=SUM(C32:C45)`

If cell `A1`

contains the value `C32:C45`

I want to modify my `A2`

formula to use that range.

I tried `=SUM(INDIRECT(ADDRESS(row(),column()-1)))`

but it didnt work... What Am I missing ?

Any other ideas that helps avoiding the multiple editing of each formulas are welcome (hopefully using native google-spreadsheet functions only -no scripting unless it's the only way :< -)