=SUMPRODUCT(--(DATE(YEAR($H$6:$H$155),MONTH($H$6:$H$155),1)=J2))
where J2 houses the criterion mont/year, that is, a true date, set to
show the first of the mont/year, like 1-Jan-2005 or a formula like:
=DATE(2005,1,1)
Keith Brown wrote:
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
|