Count "Assigned to" and Completed Year from Multiple sheets
I have 15 sheets with an "Assigned To" column. When the task it completed the task moves to an Archive sheet (there are 15 Archive sheets also) I need to count the number of completed tasks for each "assigned To" person and the year that it was completed. I have added a Date Modified column to the Archive sheet. Below is a snap shot of the matrix that I am tracking the number of open and completed tasks on. But now was requested to track the year completed.
Help Article Resources
Check out the Formula Handbook template!