I have a workbook with two sheets:
- Tracking (used multiple times a day to track time spent working on certain tasks)
- Report Template (used to report on the Tracking sheet)
Tracking contains:- Date of Task (Column B)
- Amount of Time Spent (Column C)
- Reference Number (Column E)
- Type of Activity (Column H)
Report Template contains:- Cell I7 needs to be equal to the total time spent on projects (non-procedure) by month/year
Cell I7:
=SUMIFS(Tracking!C:C,Tracking!E:E,"PROJ*",Tracking!H:H,"<>Procedure")
This function works great for totalling the amount of time spent on projects (non-procedure) throughout the entirety of the Tracking sheet. However, I need to add the additional criteria of being able to select a month and year to total (dates reside in Tracking!B:B).
I would like to reference two additional cells within this function. Those cells would contain a month (i.e. 6) and year (i.e. 2011).
Any thoughts on how I reach this goal?
Thanks!
Ryan
Bookmarks