SUMPRODUCT() with multiple expressions between dates

[tedhekman]

Ok here is the (working) formula I currently have, where Column A is a list of dates(about 0-20 entries per day) and Column B is a text string. It is returning the number of entries with the date 1/1/2004 in column A and the letter "X" in column B.
=SUMPRODUCT((A1:A2008=DATE(2004,1,1))*(B1:B2008="X"))

Now what I want to do is instead of just returning the appropriate entries with date 1/1/2004, I want to return the number of entries with a date between 1/1/2004 and 1/20/2004 - or any other dates I may specify.

Can someone please help me out? Much appreciated!

-ted

 

[Aladin Akyurek]

=SUMPRODUCT(--($A$1:$A$2008>=E2),--($A$1:$A$2008<=F2),--($B$1:$B$2008="X"))

where E2:F2 houses the date conditions with E2<=F2.

 

[tedhekman]

Works beautifully and what a fast response! Thanks!