Counting Children using OR?

Jamila

I have this formula: =COUNTIF(ANCESTORS([Schedule Health]@row), <>"Green"). It was used to count the number of children of a parent row under the Health column if health was green. I now wish to edit the formula so that it counts the number of children if health is green or blue. How can I do so? I've looked up OR but I do not see examples that use "<>".

Paul Newcome

To count for "green" or "green"/"blue", you are going to want to use the = instead of the <>. <> means "not equal to". Additionally, the ANCESTORS function will look at parent rows. To count children, you would want to use the CHILDREN function.

=COUNTIFS(CHILDREN([Schedule Health]@row), OR(@cell = "Green", @cell = "Blue"))