I have a time-sheet spreadsheet (example attached).
I am trying to create a summary sheet that states how much time an employee has worked/ taken per week.
Each employee has their own named sheet: 'name one', 'name two', etc.
The key information in these sheets are the week commencing date in col_B and the total minutes in col_F.
On the summary sheet I would like a formula to lookup the named sheet (eg: Name One in A2), check the corresponding w/c date (C1), match it to the w/c dates in sheet 'name one' col_B, and sum the relevant values in the corresponding row(s) in col_F.
I've had a look at various combinations of SUMPRODUCT, SUMIFS, INDIRECT and LOOKUP, but I can't find a combination that works and now my brain hurts. Any help would be much appreciated.
Thanks in advance!
Bookmarks