Saturday, October 27, 2012

yogi_MultiCriteria Count With Date Being Blank Or NotBlank


                                           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:C)*(Dates="")), but it just leaves blank values (--)

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