Common status: Parent/Children formula

Jana Brits

I need a formula in a parent row to return the most common value of its children:

If there are equal or more reds than yellows or greens, the parent status should be red.

If there are equal or more yellows than reds or greens, the parent status should be yellow.

If there are equal or more greens than reds or yellows, the parent status should be green.

Otherwise, the parent status should be blue.

Debbie Sawyer

Try this!

=IF(AND(COUNTIF(CHILDREN(), "Red") >= COUNTIF(CHILDREN(), "Yellow"), COUNTIF(CHILDREN(), "Red") >= COUNTIF(CHILDREN(), "Green")), "Red", IF(AND(COUNTIF(CHILDREN(), "Yellow") >= COUNTIF(CHILDREN(), "Red"), COUNTIF(CHILDREN(), "Yellow") >= COUNTIF(CHILDREN(), "Green")), "Yellow", IF(AND(COUNTIF(CHILDREN(), "Green") >= COUNTIF(CHILDREN(), "Yellow"), COUNTIF(CHILDREN(), "Green") >= COUNTIF(CHILDREN(), "Red")), "Green", "Blue")))

I think it works...?

Kind regards

Debbie