| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count within a date range | Excel Worksheet Functions | |||
| How can I count a record if it contains a date within a date range | Excel Worksheet Functions | |||
| Count cells within a date range | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| count weekdays in a date range | Excel Worksheet Functions | |||
Linear Mode
