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!
Comments
-
BTW, in the screenshot, Resource 1 shows 100 in the open column but that formula is only referencing one project. Wanted to clarify.
-
Does each project have it's own sheet?
-
Hello. Yes. Each project has its own sheet.
-
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) + ................................
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!