Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting records within a month
Hi,
I'm relatively new to Excel ... using 2003 version. I have a sheet containing items listed by date - Column B - (01/2/05 ... 02/15/05 ... etc) - each item appears on its own row. On another sheet, I want to show the current total count for each month but I don't know how to do this. Only the current month's count will change - earlier months will be static. Not every date in a month will exist in the sheet. Thank you for your help! -- JoAnn |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting records within a month
Hi JoAnn
On Sheet2 in cells A1:A12 enter 01/01/05, 02/01/05 ... 12/01/05 In cell B1 =SUMPRODUCT(--(MONTH(Sheet1!$B$1:$B$1000=MONTH((A1))) Copy down through cells B2:B12 Regards Roger Govier JoAnn wrote: Hi, I'm relatively new to Excel ... using 2003 version. I have a sheet containing items listed by date - Column B - (01/2/05 ... 02/15/05 ... etc) - each item appears on its own row. On another sheet, I want to show the current total count for each month but I don't know how to do this. Only the current month's count will change - earlier months will be static. Not every date in a month will exist in the sheet. Thank you for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Rows by Month | New Users to Excel | |||
Counting te days worked in a month | Excel Worksheet Functions | |||
Counting unique records with additional criteria | Excel Worksheet Functions | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
Counting Unique Records with multiple conditions | Excel Worksheet Functions |