Count with date range

's Computer Specifications

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?

's Computer Specifications

=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" <(E-Mail Removed)> wrote in message
news:029AEA2B-B6DD-400C-956D-(E-Mail Removed)...
>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?

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count a value in a date range based on a date in another workshee.	marsjune68	Microsoft Excel Worksheet Functions	4	9th Apr 2009 10:31 PM
How do Count a the number of times a date range appears within a date range!?	leelondon	Microsoft Excel Discussion	5	4th Oct 2006 12:12 PM
How can I count a record if it contains a date within a date range	=?Utf-8?B?aGlsZSB0cm90bWFu?=	Microsoft Excel Worksheet Functions	0	20th Sep 2006 08:58 PM
How to count dates within a certain range in a column with mutiple date range entries	Krisjhn	Microsoft Excel Worksheet Functions	2	1st Sep 2005 01:59 PM
Count between a Date Range	Miguelre	Microsoft Excel Discussion	0	24th Sep 2004 06:34 AM