Note that
=SUM(SUMIF(INDIRECT("'" & X1:X10 & "'!A1"),"X",INDIRECT("'" &X1:X10 &
"'!B1")))

Will work as well if you array enter it.

--
Regards,
Tom Ogilvy

"Frank Kabel" wrote in message
...
Hi
so lets assume you would put 'X' in cell A1 on each sheet you want to
sum and you want to sum cell B1 on each of these sheets.
1. Put a list of all worksheets on your summary sheet. e.g. in cells
X1:X10
2. Use the following formula:
=SUMPRODUCT(SUMIF(INDIRECT("'" & X1:X10 & "'!A1"),"X",INDIRECT("'" &
X1:X10 & "'!B1")))

--
Regards
Frank Kabel
Frankfurt, Germany

"Alex Jankowski" schrieb im Newsbeitrag
...
Array would be a worksheet range, a single cell on each project
sheet,
or an array saved as a workbook name.

Regards,
Alex J

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!