Count By Month

S

Shoelaces

I have searched and do not see what I need. I think it is just that I don't
understand what I am reading.

I have a coumn of dates such as 5/7/2005, 5/23/2006, etc.

I would like to produce a table that counts the number of records per month
such as:
5-2005: 32
6-2005: 16
7-2005: 24
etc.

I am struggling on how to do this. A little hand holding would be
appreciated.

Thank you.
 
D

Dave Peterson

or
=SUMPRODUCT(--(month(A2:A100)=5))




I have searched and do not see what I need. I think it is just that I don't
understand what I am reading.

I have a coumn of dates such as 5/7/2005, 5/23/2006, etc.

I would like to produce a table that counts the number of records per month
such as:
5-2005: 32
6-2005: 16
7-2005: 24
etc.

I am struggling on how to do this. A little hand holding would be
appreciated.

Thank you.
Click to expand...
 
S

Shoelaces

Teethless mama said:
=SUMPRODUCT(--(TEXT(A2:A100,"m")="5"))
Click to expand...

If I am not mistaken, this returns how many records are in the month of May.
I am interested in how many records are in May 2005, how many are in May
2006, and how many are in May 2007 individually, not collectively.
 
T

Teethless mama

=SUMPRODUCT(--(TEXT(A2:A100,"m/yy")="5/05"))

Will give you number of records in May 2005
 
D

Dave Peterson

If you're interested in all the month/years, you may want to learn about
Data|Pivottable.

It's a quick way to summarize data and you can group your dates by year and
month.
 
Top