Friday, April 18, 2014

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
---
-----------------------------------------------------------------------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem