LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Count number of row for Particular month


Hi,

I have a sheet whit the following data:

DATE Subject
April 5, 2008 citi
April 5, 2008 citi
April 6, 2008 citi
April 4, 2008 bank
April 6, 2008 bank
May 5, 2008 citi
May 7, 2008 citi
May 5, 2008 bank
May 5, 2008 bank

*Note : DATE is formatted as €˜4-5-2008 to €˜April 5, 2008

Question:
I need to count number of rows for a particular month,
Ex:
For April : 5 and May : 4
And
For April : 3 for citi and 2 for bank and May : 2 for citi and 2 for bank

Please help me€¦.

Thanks,
Praveen kumar.M

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count, number of entries of a particular month. Danny Excel Worksheet Functions 4 May 21st 07 10:05 PM
How do I count the number of even weeks in the current month. dd Excel Worksheet Functions 6 February 22nd 07 07:29 AM
How to count the number of times something occurs within a certain month Joyce Excel Worksheet Functions 1 October 18th 05 06:11 PM
Count number of items by month Christine Excel Worksheet Functions 2 September 1st 05 08:43 PM
Count number of days in given month? Bryan Excel Worksheet Functions 10 February 2nd 05 11:44 PM


All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"