In a single cell in a master spreadsheet, I am getting the value in a cell in
each of thirteen different spreadsheets and Summing them. All 13
spreadsheets referenced have the same name except for the numbers 1 - 13. As
it is now I have a Sum statement adding the result of thirteen formulas, all
of which dynamically create the filename each of which goes to a different
cell to find the numbers 1 - 13 in turn.
Instead of this long string of formulas (using the Indirect function), which
are all the same except for the cell they go to to get the number 1 - 13, I
should be able to reform the formula 13 times or steps, each step, either
incrementing the number in the spreadsheet name by 1, or starting at the
first cell and moving one column to the right to the next cell (13 cells in a
row at the top of 13 columns containing the numbers 1 - 13).
I find no Step function. Is there some other function that would do this?
Thanks,
Eric