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:
- Select the cell where you want to display the result.
- Type the following formula: =COUNTIF('Montreal Office'!A3:A5000,"*May*")
- 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.