Try this:
=SUMPRODUCT(--(B2:B65000=DATE(2008,5,2)),--(D2:D65000<0),D2:D65000)
Regards,
Stefi

€žO2 andy€� ezt Ã*rta:

Hello All,

Im trying to set build a formula that will count all dates within one
column that match the criteria for another. For example, with the formula
below, all entries on the 2nd of a month in column B with numbers less than
0, or a range of numbers in column D.

=SUMPRODUCT((B2:B65000="02/05/2008")*(D2:D65000<0))

I keep getting a value of 0. The formula below will count all the dates but
I cant get it to work when I add the range for D column.

=COUNTIF(B2:B65000,"02/05")

Also what would be the wildcard entry for the date if I wanted to show all
entries on the 2nd of any month and year.

Hope you can help.

Thanks

Andy