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

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!