SUMIF doesn't work across worksheets -- very few functions do. You may have
to combine several SUMIF statements, each pointing to s separate sheet & add
them up.

"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!!!!!!!!!!!!!!!!!!