Count By Month
 

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.

Count By Month
 

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


"Shoelaces" wrote:

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.

Count By Month
 

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





Shoelaces wrote:

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.

--

Dave Peterson

Count By Month
 

"Teethless mama" wrote:

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

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.

Count By Month
 

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

Will give you number of records in May 2005


"Shoelaces" wrote:

"Teethless mama" wrote:

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

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.

Count By Month
 

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.

Shoelaces wrote:

"Teethless mama" wrote:

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

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.

--

Dave Peterson