hmmm..... It's not working. Does it matter that the data is in a different
worksheet than the function? OR that i need to include/search the whole
entire column of data b/c this log is being continually added to?


"T. Valko" wrote:

Try something like this:

=SUMPRODUCT(--(LEFT(A1:A10)="D"),--(MONTH(B1:B10)=n))

Where n = the month number: 1 = Jan thru 12 = Dec

--
Biff
Microsoft Excel MVP


"Haydie-lady" wrote in message
...
My issue is similar, but I have one column of dates and another of various
word entries. I need to count the number of times a word begining with 'D'
was entered per month.

Any help is appreciated. Thanks





"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...