Thread: Count certain months
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default Count certain months
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