Monday, July 24, 2017

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) )