CountIFs Formula Help to Show Number of Resource Open, Closed and Overdue Tasks Across Multiple Acti
I need a COUNTIFS formula (I think this is the best option based on research) that calculates all of my technical resources task status for all of the projects. An example is below.
I have 4 current projects and 7 resources. Please see the screenshot for an idea of what I'm trying to accomplish on a Metrics sheet that totals info from the 4 projects.
Can I get help on creating a formula to count the types of tasks (Open, Closed, Overdue) for each resource (resource 1, resource2, resource3, and etc.) across all for Projects (project1, project2, project3, project4)?
Thank you for the help!
Help Article Resources
Check out the Formula Handbook template!