I am currently having trouble developing a complicated formula. I am new to the forum and have seen some real pros. Hoping someone will provide the answer needed.
What I have:
I have a workbook with around 30 sheets in it all with name tabs. (ie sheet one might be labeled bob and sheet two labeled joe). In column "A" on each sheet I have a various dates populated (ie. 02/15/2013) and in column "B" and "C" the number of hours spent working on project. (direct and indirect)
I want to take any date from any sheets that fall into a range of dates and if criteria is met add the "B" and "C" values producing one total for all sheets.
the result would be for Q1 X amount of hours were spent (X=total hours for all sheets and all cells that met the time range)
Thank you in advance
What I have:
I have a workbook with around 30 sheets in it all with name tabs. (ie sheet one might be labeled bob and sheet two labeled joe). In column "A" on each sheet I have a various dates populated (ie. 02/15/2013) and in column "B" and "C" the number of hours spent working on project. (direct and indirect)
I want to take any date from any sheets that fall into a range of dates and if criteria is met add the "B" and "C" values producing one total for all sheets.
the result would be for Q1 X amount of hours were spent (X=total hours for all sheets and all cells that met the time range)
Thank you in advance
