Recording instances of month & year

[M.Fox]

I have a formula that records the instances of the month in a range. For
example =SUMPRODUCT((MONTH(Sheet1!I4:I399)=12)*1) records the number of
instances that December occurs.

My problem is that I now need it to only count the number of instances of
December 2004 and ignore the number of instances of December 2003.

Any ideas?

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(MONTH(Sheet1!I4:I399)=12),(YEAR(Sheet1!I4:I399)=2004))

 

[Daniel.M]

Another way,

=SUMPRODUCT((Sheet1!I4:I399-DAY(Sheet1!I4:I399)=DATE(2004,12,))*1)

Regards,

Daniel M.

 

[Ron Rosenfeld]

I have a formula that records the instances of the month in a range. For
example =SUMPRODUCT((MONTH(Sheet1!I4:I399)=12)*1) records the number of
instances that December occurs.

My problem is that I now need it to only count the number of instances of
December 2004 and ignore the number of instances of December 2003.

Any ideas?

Here's one way using a different function:

=COUNTIF(A1:A100,">="&DATE(2004,12,1))-COUNTIF(A1:A100,">"&DATE(2004,12,31))


--ron

 

[M.Fox]

Many thanks to you all for taking the time to reply. I have tried them all
and confirm that they all work.

Once again, thanks.

Mark


M.Fox wrote in message ...