Home |
Search |
Today's Posts |
#1
|
|||
|
|||
counting dates
i have a column of dates (mm,dd,yyyy) how do i count how many are in each
month.... i tried this: =SUMPRODUCT(--(TEXT($A$9:$A$272,"mm")="01")) =SUMPRODUCT(--(TEXT($A$9:$A$272,"mm")="02")) =SUMPRODUCT(--(TEXT($A$9:$A$272,"mm")="03")) ..............etc but it spit out zero for oct, nov, dec when it shouldn't have.... thanks jeremy -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200508/1 |
#2
|
|||
|
|||
One way.........in cell B9 put
=MONTH(A9), and copy down......... in E1:E12 put 1 through 12....... then highlight column B and do Tools DataAnalysis Histograms.........and follow menus setting Bin as E1:F12 Vaya con Dios, Chuck, CABGx3 "jeremy via OfficeKB.com" wrote in message ... i have a column of dates (mm,dd,yyyy) how do i count how many are in each month.... i tried this: =SUMPRODUCT(--(TEXT($A$9:$A$272,"mm")="01")) =SUMPRODUCT(--(TEXT($A$9:$A$272,"mm")="02")) =SUMPRODUCT(--(TEXT($A$9:$A$272,"mm")="03")) .............etc but it spit out zero for oct, nov, dec when it shouldn't have.... thanks jeremy -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200508/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting individual dates | Excel Discussion (Misc queries) | |||
Counting dates in a column | Excel Worksheet Functions | |||
Counting Dates | Excel Worksheet Functions | |||
How to Calculate Dates without counting the weekends | Excel Worksheet Functions | |||
counting entries between two dates? | Excel Worksheet Functions |