Monday, April 8, 2013

yogi_Count Number of Instances When Column A is equal to A or Column A is equal to B; and Column B is equal to Red

                                          Google Spreadsheet   Post  #1100
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 8, 2013
user Anthony Kirk :(!category-topic/docs/spreadsheets/dXRGRGdHqp0)
Check if cell has any of a set of values
I am trying to find how many rows fulfill multiple criteria.  One of the criteria should check if a cell values contains one of a range of values.

COL1  COL2  
A        Red
B        Red
C        Blue
D        Blue

I found out how to do a count with multiple criteria, but I can't figure out how to make one of the criteria match a range of values.

I want to find out how many rows have col1 equal A or B, and col2 is Red.

following is a solution to the problem