yogi_Multi Conditional Count -- Instances Of Lister Name And List Data As Specified

                                         Google Spreadsheet   Post  #1606
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-19-2014
post by mattjones2: (https://productforums.google.com/forum/#!msg/docs/5wLczJXT2B4/WBehreNg3wUJ)
How Do I Use countif to add values before todays date?

Hi, I think I am close on this one. Can't get my date function right.

Listing Data'!C:C contains text fields, I am counting rows containing
Listing Data'!A:A is a date field.

I would like to count all NC records equal to or earlier than today's date.

I borrowed this formula from Yogi Anand. Can I just change the specified date to today() or similar?

=ArrayFormula(countif(if('Listing Data'!C:C="NC",'Listing Data'!A:A),"<=2014-4-1"))

Thanks

---

Sure can. 
https://docs.google.com/spreadsheet/ccc?key=0AoQiTwz9wADpdGZocGExX2dLaWtCVWMtcTg5a21sTXc&usp=sharing

Formula is on Summary sheet  cell, c5

-----------------------------------------------------------------------------------------------------------------------------------------------------

following is a solution to a bit more generalized problem