View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ImaGina
 
Posts: n/a
Default Counting Entries by Month and Year

Hi there ~

This is a 2-part query.

PART 1
I need a formula to count the number of entries by month and year, and enter
the count on another summary worksheet. Specifically, Worksheet 1 needs to
show how many cells in Worksheet 2, A:A, have a date that is in Jan-05, how
many Feb-05, etc. See example of Worksheet 1 below.

JAN-05 FEB-05 MAR-05
RECEIVED

PART 2
Then for each month, I need to know how many were assigned to a certain name
(in R:R).

Thanks much!