Hi,

I'm not sure you can easilly do the calculation on sheet 1 but you can do this

=SUM(Sheet2:Sheet10!A4)

Where A4 on each sheet contains the formula =A1/A2*A3

You don't need to use A4 it can be a cell out of the way somewhere.

Mike

"Werner Rohrmoser" wrote:

Hi,

I have a book with Sheet1 through Sheet10.
On Sheet2 through Sheet10 there are numbers in cell "A1", "A2" and
"A3".
What I'd like to do is to calculate directly on Sheet1 the SUM of the
single calculations on Sheet2 through Sheet10, which is "A1/A2*A3".
It would be the result of
SUM(Sheet2!A1/Sheet2!A2*Sheet2!A3, ...., Sheet10!A1/Sheet10!A2*Sheet10!
A3).
Yes, Ican calculate the formula on each sheet and use the SUM formula
with a 3D reference,
but this is not the solution I'm looking for.
Is there an array formula, which can do that?
Thanks.

Excel XP SP3
WIN XP SP3

Regards
Werner