Counting occurrences of specific month

's Computer Specifications

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.

's Computer Specifications

=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" <(E-Mail Removed)> wrote in message
news:099159F3-1D40-4D5E-9606-(E-Mail Removed)...
>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.
>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
> news:099159F3-1D40-4D5E-9606-(E-Mail Removed)...
> >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.
> >
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
counting occurences specific month appears	MM	Microsoft Excel Worksheet Functions	4	4th May 2010 04:27 PM
counting occurences of month on a specific worksheet	MM	Microsoft Excel Worksheet Functions	1	3rd May 2010 09:06 PM
Counting cells with specific month in	JRD	Microsoft Excel Worksheet Functions	7	23rd Nov 2009 12:53 AM
Counting occurrences	GARY	Microsoft Excel Misc	3	13th Aug 2008 09:51 PM
Trap some multiple occurrences of specific values in specific fiel	tuesamlarry	Microsoft Access	2	2nd Jul 2008 03:27 AM