How to calculate the number of applications per month?

Question

Google Sheets

There is a table:
https://docs.google.com/spreadsheets/d/1XtZMDJ5DUc...
How to count the number of applications made in November and December?
I tried to use COUNTIF, but you need to specify the exact value of the cell there.
Please tell me how to solve this problem?

Answer 1

=счётз(filter( a:a ; c:c >= ссылка_на_дату_от ; c:c < ссылка_на_дату_до ))

or so if hunting hardcode

=СЧЁТЗ(filter(C2:C;C2:C>=ДАТА(2020;11;1);C2:C<ДАТА(2020;12;1)))

Answer 2

If the idea is on the move, then in countif do not pass the entire cell, but 4 and 5 characters, this will be a month.
In general, for such cases, they make a pivot table. Everything you need is there

Answer 3

The criterion can be a number, expression, cell reference, text, or formula;

Can do

=COUNTIF(..., "??.11.20") + COUNTIF(...,"??.12.20")

Answer 4

=ArrayFormula(SUMIF(MONTH(A:A);12;B:B))
Where A:A you have the date B:B of the value to sum up, month 12(December). If necessary, for the current month, you can replace the month number like so Month(Today()).