Count if between two dates and matching criteria

Hi, I'm trying to set up a formula to count the number of entries between two dates in one column if they match a criteria in another.

i.e. if my data is as follows:
A_____:B
Blue___:1/01/2010
Green__:3/03/2010
Blue___:2/01/2010
Blue___:31/09/2010

I want to count Blue entries between 01/01/2010 and 30/01/2010.

So in this example the result I want is 2.

What formula can I use to do this, I've a feeling SUMPRODUCT is involved but I've had no success getting it to work... Any help would be much appreciated.

If as implied by profile you're using XL2007 you should use COUNTIFS in pref. to SUMPRODUCT given significant efficiency gains

Please Login or Register  to view this content.

where C1 & D1 hold start/end dates respectively