=SUMPRODUCT((B2:B5=1)*(MONTH(C2:C5)=1)*(YEAR(C2:C5 )=2008))


"Astro" wrote:

Currently, I have this worksheet with the following datas:

Items Accepted Date
Apple 1 30-Jan-08
Mango 0 15-Jan-08
Orange 1 20-Feb-08
Pear 1 10-Jan-08

What function must I use to count the number of accepted items in the month
of Jan of example.

Please help.
Thank you.
Best Regards...