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
A1 contains the value
C32:C45 I want to modify my
A2 formula to use that range.
=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 :< -)