I have the following type of list:
col A col B col C col D col E
Date Project Start Time Stop Time Total Hours
8/1 XYZ 10:00 13:00 3.0
8/2 XYZ 09:00 09:30 0.5
8/3 ABC 11:00 11:45 0.75
I currently have the formula to pull out the total hours for the particular project ... =SUMIFS($E$4:$E$504,$B$4:$B$504,"XYZ") ....
however, what I'm looking for is to be able to grab the same data but for a particular week (i.e., like weeknum?). I've included a copy of the file so you can see the actual columns, etc.
QA Production.xlsx
Bookmarks