Count only days equal to or prior to today Excel

[aprunkard]

I know this has got to be simple but I am pulling my hair out trying...

I want to only count dates that are equal to today and prior to today.

My Dates start in A4 and whenever there is an appointment set a line is added.
On a separate sheet I want to count all of the appointments that are for today and before. (Making it a month total)
I tried the formula:
=COUNTIF(January!A4:A65536,<=$A$1) (A1 being "TODAY()")
But Excel wants to put my criteria in quotes or it won't except it.

Anyone have any ideas?

Thanks - Amanda

 

[SkipVought]

hi,
[tt]
=sumproduct((January!A4:A65536<=$A$1)*1)
[/tt]


Skip,

_{[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment and urethric relief...
Pinot More!}

 

[aprunkard]

Okay I used:
=COUNTIF(January!A4:A65536,"<="&Today)

Which works great...

But now I am trying to use a countif statement with multiple criteria. I have tried this but, of course, it's wrong:

=SUMPRODUCT(--(January!A4:A3000,"<="&Today),--(January!D43000,='Information Pull'!E4))
I got this off of Microsoft's website.

 

[Lilliabeth]

=SUMPRODUCT((January!A7:A3000<=TODAY())*(January!D7:D3000='Information Pull'!E4))