Hi,

Try this

=SUMPRODUCT(SUMIF(INDIRECT(A2:A15&"!G8:G14"),"ALBA NYLUGE",JOE'!$H$8:$H$14)).
A2:A15 contains the names of worksheets to be summed.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"capt "c"" wrote in message
...
I have the correct sumif function I need ------------
=SUMIF('[WORKALT2000.XLS]JOE$G$8:$G$14,"=ALBANY
LUGE",'[WORKALT2000.XLS]JOE'!$H$8:$H$14)*7.15

(Joe) is a work sheet in the book. I can't seem to be able to include the
rest of the sheets in the work book as a range of sheets.

Any help would be great!!!!!!!!!!!!!!!!!!