View Single Post
  #1  
Old May 3rd, 2010, 08:41 PM posted to microsoft.public.excel.worksheet.functions
MM
external usenet poster
 
Posts: 105
Default counting occurences specific month appears

Afternoon all,
You've helped out before and I come to you again. Here's the question...

5 worksheets in my workbook, each representing a different office.
Column A for each worksheet is the date in the following format: 03-May-10.
Let's say the first sheet is named Montreal Office, the search range is
A3:A5000, what formula am I supposed to use? I think from past posts, I'm
supposed to use =sumproduct but I don't know how to incorporate my specific
sheet.

Thanks so much,
MM