"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.