countifs and wildcards to count dates
 

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

here the formula:

=countifs(...;[range];"=*"&month(A4)&"/"&year(A4);...)

this formula returns 0. If I change the wildcard with a specific day number, it works fine.

Any clue?

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

countifs and wildcards to count dates
 

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!