If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Function needed!
I need a function that will search a column of dates and count the
number of occurances in each month so I can graph the number of records by month. My first problem is seperating months using serial numbers, and my second problem is finding a function that will count based on special criteria. Any help would be greatly appreciated. Thanks dw --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Function needed!
Hi
one way =SUMPRODUCT((TEXT(range_dates,"mmm")="Jan")*1) where range_dates is the range of cells that you want to look through to see if they are in Jan hope this helps Cheers JulieD "dwboiler " wrote in message ... I need a function that will search a column of dates and count the number of occurances in each month so I can graph the number of records by month. My first problem is seperating months using serial numbers, and my second problem is finding a function that will count based on special criteria. Any help would be greatly appreciated. Thanks dw --- Message posted from http://www.ExcelForum.com/ |
#3
|
|||
|
|||
Function needed!
On Tue, 15 Jun 2004 10:42:03 -0500, dwboiler
wrote: I need a function that will search a column of dates and count the number of occurances in each month so I can graph the number of records by month. My first problem is seperating months using serial numbers, and my second problem is finding a function that will count based on special criteria. Any help would be greatly appreciated. Thanks dw The Pivot Chart and Table wizard would allow you to group your entries by month, do a count of the number of entries in each month, and graph the results. --ron |
Thread Tools | |
Display Modes | |
|
|