I want to change a number of cells in a sheet from this formula
=AVERAGE(C5:C7,C25:C27)
to this one
=AVERAGE(INDIRECT("C5:C7"),INDIRECT("C25:C27"))
The only trouble is that once the range is in quotations I can't auto fill any of the formulas to adjacent cells. The sheet is way too big to type the INDIRECT formula into each cell.
Are there any shortcuts I can use or is thre an alternative to the INDIRECT function that will do the same job?
Bookmarks