yogi_Multi-Criteria Count

Google Spreadsheet   Post  #2212

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-24-2017

question by Real Juan:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/MyDUdN2Lr4A;context-place=forum/docs

Count IF it matches one of multiple strings.

How can I COUNTIF the value is one of different strings. I want to count how many pieces of clothes are yellow or green and a wore by 12 year olds.

Working with one color
=ARRAYFORMULA(countif(D2:G6&C2:C6,B11&B10) )

Doesnt work with two colors.
=ARRAYFORMULA(countif(D2:G6&C2:C6,B11:B12&B11) )

EXAMPLE spreadsheet
https://docs.google.com/spreadsheets/d/14leFBdwPl5TdvzwIE5OOM7xoA0SSFe_CoFZVvK9JioM/edit?usp=sharing