From: Ms-Exl-Learner on
Check your other posts in the below links for answers.

http://www.microsoft.com/office/community/en-us/default.mspx?&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.excel.worksheet.functions&p=1&tid=5b0c0acc-24dc-49bf-9ec7-3d55103b4b5d

http://www.microsoft.com/office/community/en-us/default.mspx?&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.excel.worksheet.functions&p=1&tid=a51dba23-021c-44c9-888f-83e3b69b295c&mid=a51dba23-021c-44c9-888f-83e3b69b295c

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"jay" wrote:

> I have two worksheets. I would like to have a formula that counts data
> according to the following conditions.
>
> Worksheet 1
> A B C
> 02/15/2009 Keyword Keyword
> 01/14/2009 Keyword Keyword
> 01/31/2009 Keyword Keyword
>
> Worksheet 2
> A B C
> January Total Keyword Total Keyword
> February Total Keyword Total Keyword
>
> I would like staff to be able to enter data into Worksheet 1 and have
> Worksheet 2 automatically count the occurrences of the keyword in the given
> month (January or February, etc.).
>
>
>