Thread: Count the occurances of a month in a range of date fields
View Single Post
  #8   Report Post  
mijoh20
 
Posts: n/a
Default
Hello,

I tried this solution:

=SUMPRODUCT(--(ISNUMBER(A2:A1000)),--(MONTH(A2:A1000)=2))

I got #Value! in the cell. When I take the --(MONTH(A2:A1000)=2)) away
the formula works but counts all cells. What am I doing wrong?

Reply With QuoteReply With Quote