Karen
That's a mouthful. You say the time tracking sheets have dates in
Column A with a blank row between months. See if I understand you. Excel
will look at a date in Column A of the Summary sheet. Let's call that
TheDate for now. Excel will then look at each time tracking sheet and
search Column A for TheDate. If it finds TheDate, you want Excel to sum ALL
of Column Q in that sheet. Then you want Excel to look for TheDate (the
same TheDate) in the rest of the time tracking sheets and, if found, you
want those Column Qs summed as well? Do you want all those summations added
together? And what have you got against macros? <g Otto
"Karen N." wrote in message
...
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.