Count cells with condition – multiple conditions

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