Hi,

I'm trying to build a summary sheet in a workbook that contains 30
worksheets - 6 sheets are inconsequential, 23 are time tracking sheets for
individual projects, and 1 is the summary sheet. I want the summary sheet to
list every day in Column A (e.g., 11/1, 11/2, etc.), and Column B to house
the formula. I'm trying to get the formula to find the date in Summary
Column A by looking in Column A of each of the 23 sheets, and if it matches,
I want it to sum the total in Column Q.

The project time tracking sheets each have project info in the first 8 rows,
the column labels are in row 9 and then throughout the remainder of the
sheet. Time tracking is separated by a blank row followed by a new set of
column labels to start the next month. Column A = Date, Column B = project
status, Columns C-P = start/stop times, Column Q = time sum for each row

In other words, I'd like a formula (no macros, add-ins, etc.) that can
perform the following:
=SUMIF('ID 138-8:ID 1089-0'!A:A,Summary!A2,'ID 138-8:ID 1089-0'!Q:Q)
ID 138-8 = first time tracking sheet
ID 1089-0 = last time tracking sheet
Summary = summary sheet

I've spent hours trying to use consolidate, vlookup, if, dsum, etc. formulas
to no avail, and I'm just not technically savvy enough to build a
multi-functional, nested formula. Any assistance in building a 'simple'
formula is greatly appreciated!

--
~Karen N.