How do I do a COUNTIFS for a Department if the CHILD cell is either "Green" or Blank?
I'm trying to count each Active project that is below a Department that's Budget is either Green or Blank.
In the example below, for Department 4, the Budget count should be 4 not 2.
I'm using this formula =COUNTIFS(CHILDREN([Initiative Stage]@row), "Active", CHILDREN(Budget@row), "Green") but have had no luck with the variations of the OR formula.
Help Article Resources
Check out the Formula Handbook template!