Hi MM,

To count how many times May appears in column A, range A3:A5000, from the 'Montreal Office' worksheet, you can use the COUNTIF function. Here are the steps:

1. Select the cell where you want to display the result.
2. Type the following formula: =COUNTIF('Montreal Office'!A3:A5000,"*May*")
3. Press Enter.

This formula will count all the cells in the range A3:A5000 that contain the text "May" in the 'Montreal Office' worksheet.

If you prefer to use the SUMPRODUCT function, you can use the following formula:

=SUMPRODUCT(('Montreal Office'!A3:A5000=DATE(2010,5,1))*('Montreal Office'!A3:A5000<=DATE(2010,5,31)))

This formula will count all the cells in the range A3:A5000 that fall between May 1, 2010, and May 31, 2010, in the 'Montreal Office' worksheet.