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

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!
>