Hey all,
Second time on here. You were all helpful the first time round. Here's the
question:

I have 5 worksheets in my workbook. Each worksheet represents one of our
offices. Column A on each worksheet is a date in the following format:
03-May-10.
I need to count how many times May appears on a specific worksheet.
From what I've seen on other posts, I think I have to work with the
=sumproduct function but I don't know where to enter the specific worksheet.
Looking forward to your help.

MM

You want something like:
=sumproduct(--(text(sheet1!a1:a100,"yyyymmm")="2010May"))

The way you enter a worksheet, is the name followed by an exclamation point.
Even better is to let Excel enter it. When you get to the point in a formula
where you need to enter a range, just navigate to that range using your
mouse. Excel will fill in the proper range address.

Regards,
Fred

"MM" <(E-Mail Removed)> wrote in message
news:E5F55A98-E074-4E54-89A3-(E-Mail Removed)...
> Hey all,
> Second time on here. You were all helpful the first time round. Here's
> the
> question:
>
> I have 5 worksheets in my workbook. Each worksheet represents one of our
> offices. Column A on each worksheet is a date in the following format:
> 03-May-10.
> I need to count how many times May appears on a specific worksheet.
> From what I've seen on other posts, I think I have to work with the
> =sumproduct function but I don't know where to enter the specific
> worksheet.
> Looking forward to your help.
>
> MM