Counting Children Tasks with specific criteria
In a large sheet - I need to look for specific "tasks" that fall under a parent row.
Parent Row has Brand, Month, Quarter, etc.
Child Rows have specific tasks.
So I need to count the number of times im asking for "Task X" if Parent Row has "Brand Y" and is released in "Q4"
Another way to explain this -
If the parent row meets specific criteria - I need to count specific sub (child) tasks...
Help Article Resources
Check out the Formula Handbook template!