Hi,
I was wondering if anyone could help.
I want to produce a summary table that is based on Excel tab data. Within each tab, members of staff are updating to show whether they have sampled/checked work across a given quarter i.e April to June. Each piece of work is earmarked to be checked within a certain month. Once they have checked/sampled work, they manually put a date into a cell. I want a summary table to show, across a given quarter, a staff member would be 'expecting' a certain number of pieces of work. The next column would then, if they had 'checked' the work it would automatically be reflected in a completed total against the person and the quarter. Likewise, outstanding work would be totalled into the 'outstanding' cell.
From excel tab
Due Date Completed
31/01/2020 31/03/2020
28/07/2020
30/12/2019
Within the summary sheet it would show against this person, they had for the quarter (April to June), 2 pieces to mark, 1 had been completed i.e.
Completed (Q1) Outstanding
1 1
Alternatively, if the summary tab only reflected the number due for a quarter and the number completed i.e. based on those that are showing as blank cells.
I hope this makes sense? I've tried various combos of formulas but it only seems to 'read' the first part, therefore is incorrect.
Any help is appreciated.
thanks
Roni
I was wondering if anyone could help.
I want to produce a summary table that is based on Excel tab data. Within each tab, members of staff are updating to show whether they have sampled/checked work across a given quarter i.e April to June. Each piece of work is earmarked to be checked within a certain month. Once they have checked/sampled work, they manually put a date into a cell. I want a summary table to show, across a given quarter, a staff member would be 'expecting' a certain number of pieces of work. The next column would then, if they had 'checked' the work it would automatically be reflected in a completed total against the person and the quarter. Likewise, outstanding work would be totalled into the 'outstanding' cell.
From excel tab
Due Date Completed
31/01/2020 31/03/2020
28/07/2020
30/12/2019
Within the summary sheet it would show against this person, they had for the quarter (April to June), 2 pieces to mark, 1 had been completed i.e.
Completed (Q1) Outstanding
1 1
Alternatively, if the summary tab only reflected the number due for a quarter and the number completed i.e. based on those that are showing as blank cells.
I hope this makes sense? I've tried various combos of formulas but it only seems to 'read' the first part, therefore is incorrect.
Any help is appreciated.
thanks
Roni