Count number of cells that contain the month name entered in another cell

[pct5003]

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!

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>

 

[gaz_chops]

One way

=SUMPRODUCT((TEXT(E2:E10,"mmmm")=A3)*1)

or

=SUMPRODUCT(--(TEXT(E2:E10,"mmmm")=A3))

 

[Weazel]

maybe...

B3=SUMPRODUCT(--(MONTH(A3&1)=MONTH($E$2:$E$10)))

Row\Col	A​	B​	C​	D​	E​
1​	Projects Completed	Count		Overall Status	Completion Date
2​	Year to Date	8​		Completed	10/5/2015​
3​	October	2​		Completed	11/19/2015​
4​				Completed	12/18/2015​
5​				In Progress
6​				Pending
7​				Completed	12/18/2015​
8​				Completed	10/6/2015​
9​				Completed	11/18/2015​
10​				Completed	11/18/2015​

<tbody>
</tbody>