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     www.energyefficientbuild.com.    Apr 8, 2013
user Anthony Kirk :(http://productforums.google.com/forum/?zx=fpc1sri6bhir#!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.

Thanks
-------------------------------------------------------------------------------------------------------------
following is a solution to the problem

No comments:

Post a Comment