How to use a countif formula excluding specific criteria?
Ideally I am looking to write a countifs formula to represent the reporting teams count of active task by complexity, priority, and status with the exception that the completed and back log items should not be included in the active tasks total as they are not truly active
I was able to write a formula however my formula includes completed and backlog therefor the data I am reporting out is not true/correct
Looking to show that the reporting group has 1 active low complexity task due to the fact out of all of the low complexity tasks only one is truly active
Help Article Resources
Check out the Formula Handbook template!