If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|