Hi Eric

Take a look at the ROW() and COLUMN() functions.
=ROW(A1) will return 1
When copied down it will change to Row(A2) etc and return 2, 3 and so on
Similarly for Column where COLUMN(A1) will return 1 and will increment as
copied across

--
Regards
Roger Govier

"Eric" wrote in message
...
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