1. You have text and not excel dates or you have mixed values where some of
your values are text
2. You probably have blank cells which will be counted as January, try this
version of Jason's formula

=SUMPRODUCT(--(TEXT(H6:H155,"mmm")="Jan"),--(H6:H155<""))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Keith Brown" wrote in message
...
For the first response I modified it to
=SUMPRODUCT(--(MONTH($H$6:$H$155)=1))
and I am getting a #VALUE!

For the second response I modified it to
=SUMPRODUCT(--(MONTH($H$6:$H$155)=1)) and I am getting 37 but I only have
two
dates in that column with a month of January.

Any other ideas?



"Keith Brown" wrote:

I am needing to count the number of times each month is repeated in a
column.
The column is a date field in MM/DD/YY format. I attempted to change
the
format to MMMM DD, YYYY format (e.g. January 1, 2005) and count off of
the
word January, but that did not work (=COUNTIF(C:C,"*January*")).

Is there way to find out how many times a month is repeated?

Thank you