You can use the DATE() function (second criteria in cell D1)
=SUMPRODUCT(--(A1:A5000=DATE(2009,7,6)),--(B1:B5000=D1))

With your second criteria in D1 and date in C1
=SUMPRODUCT(--(A1:A5000=C1),--(B1:B5000=D1))

in case of a date range it would be
=SUMPRODUCT(--(A1:A5000=C1),--(A1:A5000<=C2),--(B1:B5000=D1))


If this post helps click Yes
---------------
Jacob Skaria


"ummone" wrote:

I need to create a count if cola and colb meet a certain criteria. Example:

A B
6-Jul dog
13-Jul dog
6-Jul cat
6-Jul dog
13-Jul dog
13-Jul dog
13-Jul cat
13-Jul dog

The count would be 2 as I am looking for dogs on July 6. The hiccup is the
date. I need it to calculate the WEEKNUM as a separate entity for each
weekending. The output should look something like this.

W/E count dog count cat
6-Jul 2 1
13-Jul 4 1

I currently have this:

=SUMPRODUCT((A2:A5001=39970)*(E2:E5001="dog"))

But I have to go in and generate a new formula for each weekending, and I
need to avoid that.

Many thanks for any help.

Regards