Outstanding Mike. Thank you, it works great.
Also thanks to the other that answered as well.

Gerald

Mike H wrote:
Try

=SUMPRODUCT(--(MONTH(Calls!A8:A500)=1),--(YEAR(Calls!A8:A500)=2008),--(Calls!G8:G500="DP"))

Mike

I just want to count the occurrences for any given month in the year. How
would you set
[quoted text clipped - 6 lines]

Gerald

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1