One way
=SUMPRODUCT(--(ISNUMBER(C1:C1000)),--(MONTH(C1:C1000)=1))
note that you cannot use this formula with C:C, you need to specify
something like C1:C1000
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"Keith Brown" wrote in message
...
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
|