Perhaps a 3D reference?

=SUM(Sheet1:Sheet100!A1)

will sum cell A1 on Sheet1 through Sheet100 (change the beginning and ending
sheet names to whatever yours are called).


"Pmxgs" wrote:

Hi,

does anyone know why this formila isn't working?
{=SUM(INDIRECT(ADDRESS(C8;D8;;E8:E108)))}
What I want to do is this: I have a workbook that has around 100 sheets (all
of these sheets are equally arranged), so i want to sum all the figures from
a determined cell from every sheet.
In the above example the C8;D8 contain the row and column numbers to
identify the cell i want to sum and the array E8:E108 has the name of the
sheets.
I don't know if the adress function works with arrays. If anyone knows how i
can do this, please help.

thanks