Google Spreadsheet Post #834
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Oct 27, 2012
user robjwill said: (http://productforums.google.com/forum/#!category-topic/docs/how-do-i/Iz-9Wx4vadM)
Countifs equivalent for Google Spreadsheet not working
I am trying to
implement a Countifs equivalent in a Google spreadsheet.
Problem 1:
Range 1 = Locations, Criteria1 = C2:C, Range 2 = Dates, Criteria2 = "".
So I am trying to count locations for each name in cols C2:C that have a blank date value in Dates range. (Note, the dates are imported from another spreadsheet using importrange, formatted as m/d/yyyy, - if that matters...)
I tried, arrayformula(sum(Locations=C2:
Problem 2:
Then, I need to do the exact same think, but for dates that are not blank.
Thanks!
Problem 1:
Range 1 = Locations, Criteria1 = C2:C, Range 2 = Dates, Criteria2 = "".
So I am trying to count locations for each name in cols C2:C that have a blank date value in Dates range. (Note, the dates are imported from another spreadsheet using importrange, formatted as m/d/yyyy, - if that matters...)
I tried, arrayformula(sum(Locations=C2:
Problem 2:
Then, I need to do the exact same think, but for dates that are not blank.
Thanks!
-------------------------------------------------------------------------------------------------
following is a solution to the problem
