| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting how many times a certain month appears
Hi all,
Fourth try's a charm....I'm getting errors trying to post my question. Here it is... 1 workbook, 4 worksheets each named for a different office. Column A for each sheet is the date in the following format 03-May-10. I need to count how many times May appears in column A, range A3:A5000, from the 'Montreal Office' worksheet. I thought I could use =countif but from other posts, it seems maybe =sumproduct is the better option. I need your help. My stats are due pretty soon. Looking forward to your replies. MM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the times a number appears | Excel Discussion (Misc queries) | |||
| counting the number of times a word appears | Excel Worksheet Functions | |||
| Searching for text & counting how many times it appears | Excel Worksheet Functions | |||
| how many times a particular day of the week appears in a given month | Excel Discussion (Misc queries) | |||
| Counting the number of times a word appears 'anywhere' on a page | New Users to Excel | |||
Threaded Mode
