PC Review


Reply
Thread Tools Rate Thread

Counting occurrences of specific month

 
 
bpoland58
Guest
Posts: n/a
 
      13th Dec 2007
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 With Quote
 
 
 
 
Peo Sjoblom
Guest
Posts: n/a
 
      13th Dec 2007
=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.
>



 
Reply With Quote
 
bpoland58
Guest
Posts: n/a
 
      13th Dec 2007
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.
> >

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:14 PM.