I just want to count the occurrences for any given month in the year. How
would you set
up the date range?

I have tried =SUMPRODUCT(--(CALLS!A8:A500=DATE(2008,1)),--(CALLS!G8:G500="DP")

)
but I get the error too few arguments.

Gerald

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