Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In a set of dates, can you count the number of Jan '07 instances?
I have a column of dates where I need to count the number of instances that
fall within Jan 1 to Jan 31 2007. I have tried to use the countif function and can only count values greater than a value or less than a value, but not between two values. Is there another way? -- Linda W |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In a set of dates, can you count the number of Jan '07 instances?
I have a column of dates where I need to count the number of instances that
fall within Jan 1 to Jan 31 2007. I have tried to use the countif function and can only count values greater than a value or less than a value, but not between two values. Is there another way? This should work... =SUMPRODUCT((C2:C100=DATE(2007,1,1))*(C2:C100<=DA TE(2007,1,31))) Use your column instead of column C like I did and change the starting point to rows to the start of your data, set the ending rows to a number that will be equal to or larger than largest row you will ever occupy. Rick |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In a set of dates, can you count the number of Jan '07 instances?
try
=SUMPRODUCT(--(daterangeDATEVALUE("12/31/2006")),--(daterange<DATEVALUE("2/1/2007"))) "Linda Woodfield" wrote: I have a column of dates where I need to count the number of instances that fall within Jan 1 to Jan 31 2007. I have tried to use the countif function and can only count values greater than a value or less than a value, but not between two values. Is there another way? -- Linda W |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In a set of dates, can you count the number of Jan '07 instanc
Thank you Rick, this did the trick. I have never used this function and had
to do some research to figure out the logic, but I will use this function lots now that I am aware of it. -- Linda W "Rick Rothstein (MVP - VB)" wrote: I have a column of dates where I need to count the number of instances that fall within Jan 1 to Jan 31 2007. I have tried to use the countif function and can only count values greater than a value or less than a value, but not between two values. Is there another way? This should work... =SUMPRODUCT((C2:C100=DATE(2007,1,1))*(C2:C100<=DA TE(2007,1,31))) Use your column instead of column C like I did and change the starting point to rows to the start of your data, set the ending rows to a number that will be equal to or larger than largest row you will ever occupy. Rick |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In a set of dates, can you count the number of Jan '07 instanc
Thanks for your help. This is exactly the function I needed.
-- Linda W "Duke Carey" wrote: try =SUMPRODUCT(--(daterangeDATEVALUE("12/31/2006")),--(daterange<DATEVALUE("2/1/2007"))) "Linda Woodfield" wrote: I have a column of dates where I need to count the number of instances that fall within Jan 1 to Jan 31 2007. I have tried to use the countif function and can only count values greater than a value or less than a value, but not between two values. Is there another way? -- Linda W |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count number of dates in a column that are within a month period.. | Excel Worksheet Functions | |||
Count number of dates | Excel Worksheet Functions | |||
Formula to count number of dates in an array | Excel Worksheet Functions | |||
How do i count number of weekdays between two dates? | Excel Worksheet Functions | |||
Count number of instances in sheet e.g. how many males/females | Excel Worksheet Functions |