Count with date range

  • Thread starter Thread starter Porlie
  • Start date Start date
P

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?
 
=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)
 
Back
Top