Saturday, December 22, 2012

yogi_Count Instances Of Occurrences Of Entries Meeting Multiple Criteria


                                          Google Spreadsheet   Post  #936
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 22, 2012
user Jonathon McLaughlin said:(http://productforums.google.com/forum/?zx=p92r8gu6ny4m#!category-topic/docs/spreadsheets/g0tBjkB46WE)
Countif based on two conditions
I values in column G 1-4 and values in column G 0-24 and want to count how many times 1 and 12 happen together. i.e. if 1 and 12, this would equal one instance.
---
Sorry the valued 0-24 are in column H.
-----------------------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem