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    Oct 27, 2012
user robjwill said: (!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.



following is a solution to the problem