Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Showing data per month & year for comparison | Excel Discussion (Misc queries) | |||
counting date entries by month & year | Excel Worksheet Functions | |||
sort dates by day then month, not by year. | Excel Worksheet Functions | |||
HELP - need to returns the current number of past month this year and ... | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions |