How do I do a COUNTIFS for a Department if the CHILD cell is either "Green" or Blank?

Question

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.

Thank you

Sameer Karkhanis · Accepted Answer

You are only checking if the children are Green so it is obvious that it will count only those that are green. For the ones which are blank you need to add that as an OR condition as below,

COUNTIFS(...........CHILDREN(Budget@row), OR(@cell="Green", @cell=""))