Il giorno venerdì 2 ottobre 2015 10:07:23 UTC+2, Claus Busch ha scritto:
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

I forgot to thank you!