Thread: countifs and wildcards to count dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default countifs and wildcards to count dates
Hi,

Am Fri, 2 Oct 2015 00:38:42 -0700 (PDT) schrieb
:

I have a countifs functions which has, among other criteria, to count all the dates of a certain month and year.

better use SUMPRODUCT:

=SUMPRODUCT(--(MONTH(A1:A100)=MONTH(A1)),--(YEAR(A1:A100)=YEAR(A1)))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote