Multi-criteria countif functions for dates...possible?

Did you enter the formula with CNTRL-SHIFT-ENTER?

- Clay

Just tried it, now it gives me 118 which is way too high.

Here's the file it if makes things easier:
http://cjoint.com/?klxmUESqZ0

Thanks Clay,
Rekli

Sorry, thought you'd have a formula in column D. Use the following:

=SUM(IF(NOT(ISBLANK(Data!$D$2:$D$1657))*(MONTH(Data!$A$2:$A$1657)=MONTH(A2))*(YEAR(A2 )=YEAR(Data!$A$2:$A$1657))*(Data!$D$2:$D$1657>=0)*(Data!$D$2:$D$1657<=2),1))

With CNTRL-SHIFT-ENTER

- Clay Ver Valen
Excel Help

That worked beautifully...thanks Clay!