Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting cells with specific month in | Excel Worksheet Functions | |||
Counting number of times a specific word appears in a single cell | Excel Discussion (Misc queries) | |||
Counting occurrences of specific month | Excel Discussion (Misc queries) | |||
Counting the number of times a specific character appears in a cell | Excel Worksheet Functions | |||
Counting occurences of a specific day between two dates | Excel Worksheet Functions |