Hi

Rather than trying to use an array formula, just create a new sheet
called First and another called Last.
Drag these sheets to positions where your 100 sheets to be added are
"sandwiched" between them with your summary sheet outside of this
sandwich.
On your Summary sheet
=SUM(First:Last!C8:D8)
You can hide First and Last if you wish
--
Regards

Roger Govier


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