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 of month on a specific worksheet
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 |
#2
|
|||
|
|||
counting occurences of month on a specific worksheet
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|