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    Dec 22, 2012
user Jonathon McLaughlin said:(!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