COUNTIFS based on Children criteria of certain row
Context: Please see screenshot attached. Project Manager "Fred" has 2 "active" projects in January: Project 1 and Project 2, which are Children under "Fred". This count of 2 is determined by some percentage of the project being completed.
Goal: Count the number of active projects per month based on % complete being greater than 0.
Request: Can someone please provide me with the appropriate COUNTIF formula based on these criteria? Thank you so much in advance!
Help Article Resources
Check out the Formula Handbook template!