Countifs - with Hierarchy (Grandchild)
I am trying to write a formula to count the lowest level of "Completed" items. I have multiple Projects and different Status all on the same sheet.
=COUNTIFS((CHILDREN[Variable Features/Tasks]:[Variable Features/Tasks]), Status:Status, "Complete", Project:Project, "Test")
I'm not working in excel - I just wrote up the example there.
Help Article Resources
Check out the Formula Handbook template!