count if

[Old Wolf]

I am trying to build a formula that will check a range of cells contain
dates (i.e. 3 July 2002) and return the count of all cells for example occur
within July 2002, August 2002, etc. I have tried several methods with no
success.

Any help is appreciated.

 

[Dave R.]

Something like this will work with dates in E5:E7;

=SUMPRODUCT((MONTH(E5:E7)=7)*(YEAR(E5:E7)=2003))

adjust the 7 and 2003 parts.

 

[Old Wolf]

Works like a champ! Thanks so much.

Something like this will work with dates in E5:E7;

=SUMPRODUCT((MONTH(E5:E7)=7)*(YEAR(E5:E7)=2003))

adjust the 7 and 2003 parts.