sumif function
 

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

sumif function
 

Correct, SUMIF does not support 3D references.

My suggestion would be to have a SUMIF function on each sheet (To minimize
key strokes, select all sheets of interest, then just type the formula once)

Then on your summary sheet, you could use a SUM function with a 3D reference
through your SUMIF formulas.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"capt "c"" wrote:

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

sumif function
 

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

sumif function
 

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