View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay Jay is offline
external usenet poster
 
Posts: 671
Default Countif Formulas

I have two worksheets. I want to feed data from one to the next to tally
occurrences of key words in two columns according to month in another column

Worksheet 1
A B C
01/15/2009 Keyword Keyword
01/05/2009 Keyword Keyword
02/12/2009 Keyword Keyword

Worksheet 2
A B C
January Count KeyWord Worksheet 1 Count Keyword Worksheet 1
February Count Keyword Worksheet 1 Count Keyword Worksheet 1

How can I have the entries from worksheet one auto-count on worksheet 2 for
stat totals?