| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting occurrences of specific month
I have a column oof dates and times (ex. 11/19/2007 1:50:00 PM). Is there any
way to count the number of times there is an entry for the month only. In this example the month of Nov. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting occurrences of specific month
=SUMPRODUCT(--(ISNUMBER(A1:A20)),--(MONTH(A1:A20)=11))
if you get a value error then they are text and not numerical Excel dates -- Regards, Peo Sjoblom "bpoland58" wrote in message ... I have a column oof dates and times (ex. 11/19/2007 1:50:00 PM). Is there any way to count the number of times there is an entry for the month only. In this example the month of Nov. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting occurrences of specific month
Thanks That does it.
"Peo Sjoblom" wrote: =SUMPRODUCT(--(ISNUMBER(A1:A20)),--(MONTH(A1:A20)=11)) if you get a value error then they are text and not numerical Excel dates -- Regards, Peo Sjoblom "bpoland58" wrote in message ... I have a column oof dates and times (ex. 11/19/2007 1:50:00 PM). Is there any way to count the number of times there is an entry for the month only. In this example the month of Nov. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of occurrences. | Excel Worksheet Functions | |||
| counting random occurrences | Excel Discussion (Misc queries) | |||
| Counting occurrences on a particular date | Excel Worksheet Functions | |||
| Counting number of occurrences | Excel Worksheet Functions | |||
| counting occurrences in a range | Excel Discussion (Misc queries) | |||
Linear Mode
