Thread: Count certain months
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scott
 
Posts: n/a
Default Count certain months
John did not work not

"John Michl" wrote:

Try the following array formula:

=SUM(IF(MONTH(A1:A5)=12,1,0)) commit it by hitting Ctrl-Shift-Enter

- John
www.JohnMichl.com


Reply With QuoteReply With Quote