Count with date range
 

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?

Count with date range
 

=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" wrote in message
...
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?

Count with date range
 

Thanks, worked a treat

"Porlie" wrote:

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?