Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!!!!!!!!!!!!!!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!!!!!!!!!!!!!!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!!!!!!!!!!!!!!!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!!!!!!!!!!!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
Using the TODAY() function in a SUMIF function | Excel Worksheet Functions | |||
How do I use the TODAY function with the SUMIF function? | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |