Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count, number of entries of a particular month. | Excel Worksheet Functions | |||
How do I count the number of even weeks in the current month. | Excel Worksheet Functions | |||
How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
Count number of items by month | Excel Worksheet Functions | |||
Count number of days in given month? | Excel Worksheet Functions |