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