In my project schedule, I have several columns including the following:
- progress (on track, at risk, behind schedule)
-functional area (dept1, dept2, dept3)
-status (complete, not started, in progress)
I'm trying to create a summary sheet that tells me :
Overall % of on track, % of at risk, % of behind schedule
Dept2 % of on track, % of at risk, % of behind schedule
I'm trying to use CountIfs but it not working.
Help Article Resources
Check out the Formula Handbook template!