We did see who we can get total of a column for a certain month in certain year using SUMIFS.
SUMIFS got a sister function, COUNTIFS
Which will count how many times cells found with more than 1 condition
So, when you have a table like this…
All you need to do is to get how many times a certain month found, is to use this formula…
As you can see in cell H6