CountIFs Formula Help to Show Number of Resource Open, Closed and Overdue Tasks Across Multiple Acti

edited 12/09/19 in Formulas and Functions

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!