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
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
No comments:
Post a Comment