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

Comments

comments