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

CB_OSG

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!

 

CB_OSG

BTW, in the screenshot, Resource 1 shows 100 in the open column but that formula is only referencing one project.  Wanted to clarify.  

Paul Newcome

Does each project have it's own sheet?

CB_OSG

Hello.  Yes.  Each project has its own sheet.  

Paul Newcome

Then you will need to use your Project 1 Formula, Replicate it for Project 2, then add them together.

 

=COUNTIFS(Project 1 Formula) + COUNTIFS(Project 2 Formula) + COUNTIFS(Project 3 Formula) + ................................