Perfect. Thanks guys, I orginally got most of it but I'm still shaky on
quotation marks and parathesis!

"Pete_UK" wrote:

Assuming you have dates in column M:

=SUMPRODUCT((D2:D5000<"")*(MONTH(M2:M5000)=5)*(YE AR(M2:M5000)=2007))

Hope this helps.

Pete

On Mar 28, 4:18 pm, luisi wrote:
I'm trying to come up with a SUMPRODUCT or COUNTIF Equation with no luck
(syntax maybe???).

I'm trying to count the nonblank cells from D2:D5000 with the following
criteria.

Month in column M (M2:M5000)=5
Year in column M (M2:M5000)=2007