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!