sumif function

[capt c]

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

 

[Luke M]

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.

 

[Bob Umlas]

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.

 

[Ashish Mathur]

Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com