=SUMPRODUCT((A7:A377<TODAY())*(C7:C377=0))
--
David Biddulph

"Sean" wrote in message
oups.com...
I have dates listed in Column A7:A377. How can I incorporate this
formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377
are less than TODAY()

Thanks