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

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