pct5003
New Member
- Joined
- Nov 6, 2013
- Messages
- 4
Hello Friends,
I am struggling with creating the proper formula. I am trying to be able to display the count of cells that contain dates for a specific month I enter in another cell. Also I am using a separate tab to convert the month into a number. I tried using countif, but it does not appear to work. Below is an example of some of the data. I want to be able to display the count next to the month. Thanks in advance for the help!
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I am struggling with creating the proper formula. I am trying to be able to display the count of cells that contain dates for a specific month I enter in another cell. Also I am using a separate tab to convert the month into a number. I tried using countif, but it does not appear to work. Below is an example of some of the data. I want to be able to display the count next to the month. Thanks in advance for the help!
Projects Completed | Count | Overall Status | Completion Date | |
Year to Date | 8 | Completed | 10/5/2015 | |
October | Completed | 11/19/2015 | ||
Completed | 12/18/2015 | |||
In Progress | ||||
Pending | ||||
Completed | 12/18/2015 | |||
Completed | 10/6/2015 | |||
Completed | 11/18/2015 | |||
Completed | 11/18/2015 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>