COUNTIFS with date range

[Explorador]

Hi, I am having trouble getting a count of the number of entries with lead dates in September and the language "ES". The screenshot only contains part of the spreadsheet but I can extend the range in the formula if given the general idea of what needs to be done! Could someone help me?

 

[Explorador]

Inbound_Marketing_Specialist_-_Test.xlsx
	A	B	C	D	E	F	G
80
81		Dates	Language	Total Leads	Total Customers	Conversion rate from Leads/Customers	Average BOFU Customers
82		Sep-20	ES
83		Sep-20	EN
84		Sep-20	FR
85		Oct-20	DE
86		Oct-20	IT
87		Oct-20	EN
88
89
90	Lead Date	Sign up date	Customer date	Language	Funnel Source	Funnel Stage
91	10/29/20	10/29/20	10/30/20	EN	Organic	BOFU
92	10/20/20	10/20/20	11/1/20	EN	Paid	BOFU
93	10/19/20	10/19/20	11/4/20	EN	Organic	BOFU
94	10/18/20	10/18/20	10/28/20	EN	Organic	BOFU
95	10/17/20	10/17/20	10/20/20	EN	Organic	BOFU
96	10/17/20	10/9/20	10/22/20	EN	Paid	BOFU
97	10/15/20	10/15/20	10/16/20	EN	Paid	BOFU
98	10/16/20	10/16/20	10/21/20	IT	Organic	BOFU
99	10/14/20	10/15/20	10/27/20	EN	Paid	BOFU
100	10/13/20	10/24/20	10/26/20	IT	Organic	TOFU
101	10/12/20	10/12/20	10/18/20	IT	Organic	TOFU
102	10/11/20	10/11/20	10/11/20	EN	Paid	BOFU
103	10/11/20	10/23/20	10/26/20	EN	Paid	BOFU
104	10/11/20	10/11/20	10/22/20	IT	Organic	TOFU
105	10/10/20	10/1/20	10/8/20	EN	Paid	BOFU
106	10/9/20	10/10/20	10/13/20	EN	Organic	TOFU
107	10/9/20	10/5/20	10/5/20	EN	Organic	BOFU
108	10/8/20	10/8/20	10/9/20	EN	Paid	BOFU
109	10/5/20	10/6/20	10/18/20	EN	Paid	BOFU
110	10/5/20	10/10/20	11/2/20	EN	Paid	BOFU
111	10/5/20	10/5/20	10/9/20	EN	Organic	BOFU
112	10/3/20	10/3/20	10/8/20	EN	Paid	BOFU
113	10/2/20	10/3/20	1/0/00	EN	Organic	BOFU
114	10/2/20	10/25/20	1/0/00	EN	Organic	TOFU
115	10/2/20	10/2/20	10/19/20	EN	Paid	BOFU
116	10/2/20	10/2/20	1/0/00	EN	Organic	BOFU
117	10/2/20	10/2/20	1/0/00	EN	Paid	BOFU
118	10/2/20	10/5/20	1/0/00	EN	Organic	TOFU
119	10/2/20	10/2/20	10/17/20	EN	Paid	TOFU
120	10/2/20	10/2/20	1/0/00	EN	Paid	BOFU
121	10/2/20	10/17/20	10/17/20	EN	Organic	BOFU
122	10/1/20	10/8/20	1/0/00	IT	Organic	TOFU
123	10/1/20	10/1/20	1/0/00	EN	Organic	BOFU
124	10/1/20	10/22/20	1/0/00	EN	Organic	TOFU
125	8/6/20	8/6/20	9/23/20	DE	Organic	TOFU
126	10/1/20	1/0/00	1/0/00	EN	Organic	TOFU
127	10/1/20	1/0/00	1/0/00	EN	Organic	TOFU
128	10/1/20	1/0/00	1/0/00	IT	Organic	TOFU
129	10/1/20	1/0/00	1/0/00	EN	Organic	TOFU
130	10/1/20	1/0/00	1/0/00	EN	Organic	TOFU
131	10/1/20	1/0/00	1/0/00	EN	Organic	BOFU
132	10/1/20	1/0/00	1/0/00	EN	Organic	TOFU
133	10/1/20	1/0/00	1/0/00	EN	Organic	BOFU
134	10/1/20	10/1/20	1/0/00	EN	Organic	TOFU
135	10/1/20	1/0/00	1/0/00	EN	Organic	TOFU
136	10/1/20	1/0/00	1/0/00	EN	Organic	BOFU
137	10/1/20	1/0/00	1/0/00	EN	Organic	BOFU
138	10/1/20	10/1/20	1/0/00	EN	Organic	BOFU
139	10/1/20	10/24/20	1/0/00	EN	Organic	TOFU
140	10/1/20	1/0/00	1/0/00	EN	Organic	TOFU
141	9/30/20	9/30/20	10/2/20	EN	Organic	TOFU
142	9/28/20	9/28/20	1/0/00	EN	Paid	BOFU
143	9/11/20	9/11/20	10/12/20	EN	Organic	TOFU
144	9/11/20	9/11/20	9/12/20	EN	Paid	BOFU
145	9/10/20	9/13/20	9/13/20	EN	Organic	BOFU
146	9/10/20	9/10/20	9/19/20	EN	Organic	BOFU
147	9/9/20	9/9/20	9/23/20	EN	Organic	BOFU
148	9/9/20	9/9/20	9/20/20	EN	Paid	BOFU
149	9/8/20	9/9/20	9/13/20	EN	Paid	BOFU
150	10/2/20	10/2/20	1/0/00	ES	Organic	TOFU
151	9/8/20	10/2/20	10/11/20	EN	Organic	BOFU
152	10/2/20	10/2/20	1/0/00	ES	Paid	BOFU
153	9/7/20	9/7/20	9/15/20	EN	Organic	BOFU
154	9/6/20	9/6/20	9/8/20	EN	Paid	BOFU
155	10/2/20	10/2/20	1/0/00	ES	Organic	TOFU
156	10/2/20	10/2/20	1/0/00	ES	Organic	TOFU
157	10/2/20	10/2/20	1/0/00	ES	Paid	BOFU
158	9/6/20	9/6/20	9/6/20	EN	Paid	BOFU
159	9/6/20	9/8/20	9/10/20	EN	Paid	BOFU
160	10/1/20	1/0/00	1/0/00	IT	Organic	TOFU
161	9/14/20	9/19/20	9/19/20	IT	Paid	BOFU
162	9/6/20	9/6/20	9/14/20	EN	Paid	BOFU
163	9/4/20	9/29/20	10/2/20	EN	Paid	BOFU
164	10/1/20	1/0/00	1/0/00	ES	Paid	BOFU
165	9/4/20	10/14/20	10/15/20	EN	Paid	BOFU
166	9/4/20	9/22/20	10/9/20	EN	Organic	BOFU
167	9/3/20	9/3/20	9/19/20	EN	Paid	BOFU
168	9/2/20	9/2/20	9/3/20	EN	Paid	BOFU
169	9/2/20	9/2/20	1/0/00	EN	Paid	BOFU
170	9/2/20	9/2/20	1/0/00	EN	Paid	BOFU
171	9/2/20	9/2/20	1/0/00	EN	Organic	BOFU
172	9/1/20	9/1/20	1/0/00	EN	Paid	BOFU
173	9/1/20	9/1/20	1/0/00	EN	Organic	BOFU
174	9/1/20	9/1/20	1/0/00	EN	Paid	BOFU
175	9/1/20	9/3/20	1/0/00	EN	Organic	TOFU
176	9/1/20	9/1/20	1/0/00	EN	Paid	BOFU
177	10/1/20	1/0/00	1/0/00	FR	Organic	TOFU
178	9/12/20	10/2/20	10/2/20	IT	Organic	BOFU
179	9/1/20	9/1/20	1/0/00	EN	Organic	BOFU
180	9/2/20	9/2/20	1/0/00	FR	Organic	TOFU
181	9/1/20	9/1/20	1/0/00	EN	Organic	TOFU
182	9/1/20	9/1/20	1/0/00	EN	Paid	BOFU
183	9/1/20	9/1/20	1/0/00	EN	Paid	BOFU
184	9/1/20	1/0/00	1/0/00	EN	Organic	TOFU
185	9/1/20	1/0/00	1/0/00	EN	Organic	TOFU
186	9/1/20	9/1/20	1/0/00	ES	Organic	TOFU
187	9/1/20	9/4/20	1/0/00	IT	Organic	TOFU
188	9/1/20	9/25/20	1/0/00	ES	Organic	TOFU
189	9/1/20	1/0/00	1/0/00	EN	Organic	TOFU
190	9/1/20	1/0/00	1/0/00	EN	Organic	TOFU
191	9/1/20	1/0/00	1/0/00	EN	Organic	TOFU
192	9/1/20	1/0/00	1/0/00	EN	Organic	BOFU
193	9/1/20	1/0/00	1/0/00	EN	Organic	TOFU
194	9/1/20	1/0/00	1/0/00	EN	Organic	TOFU
195	9/1/20	9/1/20	1/0/00	EN	Organic	TOFU
196	9/1/20	1/0/00	1/0/00	EN	Organic	TOFU
197	9/1/20	1/0/00	1/0/00	EN	Organic	TOFU
198	9/1/20	9/1/20	1/0/00	EN	Paid	BOFU
199	9/1/20	1/0/00	1/0/00	EN	Paid	BOFU
200	9/1/20	1/0/00	1/0/00	FR	Organic	TOFU
201	9/1/20	1/0/00	1/0/00	EN	Organic	TOFU
202	9/1/20	1/0/00	1/0/00	EN	Organic	TOFU
203	8/31/20	1/0/00	1/0/00	EN	Organic	TOFU
204	8/8/20	9/20/20	9/25/20	EN	Organic	BOFU
205	8/8/20	8/28/20	8/29/20	EN	Organic	BOFU
206	8/8/20	8/8/20	1/0/00	EN	Organic	TOFU
207	8/8/20	8/8/20	1/0/00	EN	Paid	BOFU
208	8/7/20	8/7/20	1/0/00	EN	Organic	TOFU
209	8/7/20	8/8/20	1/0/00	EN	Paid	BOFU
210	8/7/20	8/7/20	8/18/20	EN	Paid	BOFU
211	9/1/20	1/0/00	1/0/00	ES	Organic	TOFU
212	8/7/20	8/7/20	1/0/00	EN	Organic	BOFU
213	8/6/20	8/7/20	1/0/00	EN	Organic	BOFU
214	8/31/20	1/0/00	1/0/00	IT	Organic	TOFU
215	8/6/20	8/6/20	8/28/20	EN	Paid	BOFU
216	8/8/20	8/8/20	1/0/00	ES	Organic	TOFU
217	8/6/20	8/6/20	1/0/00	EN	Paid	BOFU
218	8/6/20	8/6/20	1/0/00	EN	Organic	BOFU
219	8/6/20	8/6/20	1/0/00	EN	Paid	BOFU
220	8/6/20	8/6/20	9/23/20	EN	Paid	BOFU
221	8/7/20	9/15/20	1/0/00	FR	Paid	BOFU
222	8/6/20	8/6/20	1/0/00	EN	Organic	TOFU
223	8/6/20	8/6/20	1/0/00	EN	Paid	BOFU
224	8/6/20	9/30/20	1/0/00	ES	Organic	TOFU
225	8/5/20	8/6/20	1/0/00	EN	Organic	BOFU
226	8/5/20	8/5/20	1/0/00	EN	Organic	TOFU
227	8/5/20	8/5/20	1/0/00	EN	Organic	TOFU
228	8/5/20	8/5/20	1/0/00	EN	Organic	TOFU
229	8/4/20	8/15/20	1/0/00	EN	Organic	BOFU
230	8/4/20	10/7/20	1/0/00	EN	Paid	BOFU
231	8/4/20	8/4/20	1/0/00	EN	Organic	TOFU
232	8/3/20	8/17/20	1/0/00	EN	Organic	TOFU
233	8/4/20	8/4/20	1/0/00	IT	Paid	BOFU
234	8/3/20	8/3/20	1/0/00	EN	Organic	BOFU
235	8/3/20	8/3/20	1/0/00	EN	Paid	BOFU
236	8/3/20	8/3/20	1/0/00	EN	Organic	TOFU
237	8/3/20	8/3/20	1/0/00	EN	Paid	BOFU
238	8/3/20	8/3/20	1/0/00	EN	Organic	TOFU
239	8/3/20	8/3/20	1/0/00	EN	Organic	BOFU
240	8/2/20	8/3/20	1/0/00	EN	Organic	BOFU
241	8/2/20	8/3/20	8/16/20	EN	Organic	TOFU
242	8/2/20	8/2/20	1/0/00	EN	Paid	BOFU
243	8/2/20	8/2/20	1/0/00	EN	Paid	BOFU
244	8/3/20	8/5/20	1/0/00	ES	Organic	TOFU
245	8/3/20	8/23/20	1/0/00	IT	Organic	TOFU
246	8/2/20	8/2/20	1/0/00	EN	Organic	TOFU
247	8/2/20	8/15/20	1/0/00	ES	Paid	TOFU
248	8/2/20	8/12/20	1/0/00	EN	Paid	BOFU
249	8/2/20	8/2/20	1/0/00	EN	Paid	BOFU
250	8/1/20	8/1/20	8/8/20	EN	Paid	BOFU
251	8/1/20	8/1/20	1/0/00	EN	Organic	TOFU
252	8/1/20	8/1/20	1/0/00	EN	Organic	TOFU
253	8/1/20	8/2/20	1/0/00	IT	Organic	TOFU
254	8/1/20	8/1/20	1/0/00	EN	Organic	TOFU
255	8/1/20	8/1/20	1/0/00	EN	Organic	BOFU
256	8/1/20	8/1/20	1/0/00	EN	Organic	TOFU
257	8/1/20	8/1/20	8/7/20	EN	Paid	TOFU
258	8/1/20	1/0/00	1/0/00	EN	Organic	TOFU
259	8/1/20	1/0/00	1/0/00	ES	Organic	TOFU
260	8/1/20	1/0/00	1/0/00	EN	Organic	TOFU
261	8/1/20	1/0/00	1/0/00	EN	Organic	TOFU
262	8/1/20	1/0/00	1/0/00	FR	Organic	TOFU
263	8/1/20	1/0/00	1/0/00	ES	Organic	TOFU
264	8/1/20	1/0/00	1/0/00	FR	Organic	TOFU
265	8/1/20	1/0/00	1/0/00	IT	Organic	TOFU
266	8/1/20	1/0/00	1/0/00	FR	Organic	TOFU
267	8/1/20	1/0/00	1/0/00	EN	Organic	TOFU
268	8/1/20	8/1/20	8/17/20	EN	Paid	BOFU
269	8/1/20	1/0/00	1/0/00	IT	Organic	BOFU
270	8/1/20	1/0/00	1/0/00	IT	Organic	TOFU
271	8/1/20	1/0/00	1/0/00	EN	Paid	BOFU
272	8/1/20	1/0/00	1/0/00	FR	Organic	TOFU
273	8/1/20	1/0/00	1/0/00	EN	Organic	TOFU
274
275
276
277
278
279
Reporting test

 

[Fluff]

How about

=SUMPRODUCT((TEXT($A$91:$A$273,"mmmyy")=TEXT(B82,"mmmyy"))*($D$91:$D$273=C82))