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…
=COUNTIFS(B:B,">="&DATE(F6,G6,1),B:B,"<"&DATE(F6,G6+1,1))
As you can see in cell H6
