Hi Eric

I had missed the point that you were trying to do the Sum all in one cell.
That being the case, I would use a common cell on all subsidiary sheets to
pick up the value required.
e.g. on Sheet1 X1=B1, on Sheet2 X1=C1 etc.
Insert two new sheets.
Rename them as First and Last
Drag them so that you have Summary Sheet, First, Sheet1, Sheet2 ......
Sheet12, Last i.e first and Last "sandwich" the sheets you want to sum.
Then your formula on the Summary sheet becomes simply
=SUM(First:Last!X1)
--
Regards
Roger Govier

"Eric" wrote in message
...
Thanks Roger,
I have looked at the column function at your suggestion, but I don't see
how
it can help with this particular problem. My formula runs from a single
cell, and I need to add together the results of references to a cell in 13
spreadsheets, each with the same name, except a number from 1 - 13.
I want to cycle 13 times through the dynamic creation of each file name,
reference the cell in that file, add it to the accumulating sum with a "+"
sign, and create the next file name either incrementing the number by "1",
or
picking up the value in a contiguous row of cells (1 - 13).
Eric

"Roger Govier" wrote:

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