Countifs formula using or

Monica

Hello.  I am trying to count the RYG ball (in this case red) for each team.  One of our teams is comprised of three sub-teams, so I need for it to be counted if any of those show a red ball.  How do I create or for the Team section of this formula?

=COUNTIFS([Overall KPO Status]:[Overall KPO Status], "Red", Team:Team, {"Loyalty", "Partnership", "Portfolio Marketings"})

I searched the community for similar questions and checked the Smarsheet Formula Examples sheet, but I still can figure it out.

Any assistance would be greatly appreciated.

MattH

Try: 

=COUNTIFS(CHILDREN(), "Red", CHILDREN(Team:Team), "Loyalty")

Monica

Thank you!

Monica

My solution in April was to break up the formulas for red, yellow, and green for each sub-team.  

=COUNTIFS([Overall KPO Status]:[Overall KPO Status], "Red", Team:Team, "Sub-Team1")

=COUNTIFS([Overall KPO Status]:[Overall KPO Status], "Red", Team:Team, "Sub-Team2")

=COUNTIFS([Overall KPO Status]:[Overall KPO Status], "Red", Team:Team, "Sub-Team3")

 

And then, I summed the children rows for each color individually for the overall team.

=SUM(CHILDREN())

 

That ended up being 16 rows worth of formulas when I was hoping to use 3 rows by creating one formula for each color to include all the sub-teams.

 

Does that make sense?