Count with date range

[Porlie]

I need help to count data that are between dates. Col A "Red", "Blue", Col B
"date"
I need to count all the reds in col A that are between 01/07/08 + 31/07/08,
any ideas?

 

[Bob Phillips]

=SUMPRODUCT(--(A2:A200="Red"),--(B2:B200>=--"2008-07-01"),--(B2:B200<=--"2008-07-31"))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Porlie]

Thanks, worked a treat