| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count the occurance of a particular month in a column of dates
I'm having no luck getting a total count of the number of times a particular
month is present in a date column. This is what I've been trying to get a count of the number of dates that fall in the month of July, regardless of the year: =COUNT(MONTH(I$1:I286),7) Can anyone help me solve this little problem |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count the occurance of a particular month in a column of dates
=Sumproduct(--(MONTH(I$1:I286)=7))
best wishes Sreedhar "Ray Sr" wrote: I'm having no luck getting a total count of the number of times a particular month is present in a date column. This is what I've been trying to get a count of the number of dates that fall in the month of July, regardless of the year: =COUNT(MONTH(I$1:I286),7) Can anyone help me solve this little problem |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count the occurance of a particular month in a column of dates
That worked fine, but I have column headings every 41 rows for printing
purposes which I think screwed things up a bit, so I used that formula to do sub-totals before each new set of headings and it worked great! Thanks "yshridhar" wrote: =Sumproduct(--(MONTH(I$1:I286)=7)) best wishes Sreedhar "Ray Sr" wrote: I'm having no luck getting a total count of the number of times a particular month is present in a date column. This is what I've been trying to get a count of the number of dates that fall in the month of July, regardless of the year: =COUNT(MONTH(I$1:I286),7) Can anyone help me solve this little problem |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count occurance of a month in a column of dates? | Excel Worksheet Functions | |||
| count number of dates in a column that are within a month period.. | Excel Worksheet Functions | |||
| Count number of cells of a particular month in a column of dates | Excel Discussion (Misc queries) | |||
| count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions | |||
| Excell: count occurance of letters in a column | Excel Worksheet Functions | |||
Linear Mode
