| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT INBETWEEN A DATE RANGE
Hi
Does anyone know how to count the number of occurences between a data range? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT INBETWEEN A DATE RANGE
let's say your criteria in C1: early date, D1: latest date
date in column A, and number in column B =SUMPRODUCT((A1:A100=C1)*(A1:A100<=D1)*(B1:B100< "")) "Dave" wrote: Hi Does anyone know how to count the number of occurences between a data range? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT INBETWEEN A DATE RANGE
Sorry...I missed typed this. What I emant was a date range.
Thanks "Teethless mama" wrote: let's say your criteria in C1: early date, D1: latest date date in column A, and number in column B =SUMPRODUCT((A1:A100=C1)*(A1:A100<=D1)*(B1:B100< "")) "Dave" wrote: Hi Does anyone know how to count the number of occurences between a data range? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT INBETWEEN A DATE RANGE
On Thu, 18 Mar 2010 06:56:01 -0700, Dave
wrote: Hi Does anyone know how to count the number of occurences between a data range? Thanks =countif(rng,"=" & StartDate) - countif(rng,"" & EndDate) --ron |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT INBETWEEN A DATE RANGE
That's what TM assumed. What happened when you tried his suggestion?
Regards, Fred "Dave" wrote in message ... Sorry...I missed typed this. What I emant was a date range. Thanks "Teethless mama" wrote: let's say your criteria in C1: early date, D1: latest date date in column A, and number in column B =SUMPRODUCT((A1:A100=C1)*(A1:A100<=D1)*(B1:B100< "")) "Dave" wrote: Hi Does anyone know how to count the number of occurences between a data range? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count a value in a date range based on a date in another workshee. | Excel Worksheet Functions | |||
| Count with date range | Excel Worksheet Functions | |||
| 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 | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Linear Mode
