COUNTIFS

Explanation

COUNTIFS function allows us to check multiple criteria within multiple columns, and to count the number of occurrences where all criteria were met.

For example – How many employees in London received a yearly bonus?

 

Syntax

=COUNTIFS(criteria_range1,criteria1,[criteria_range2],[criteria2]…)

criteria_range1 – What is the first range we would like to check?

criteria1 – What’s the first criteria to check in this range?

criteria_range2 (optional) – What is the second range we would like to check?

criteria2 (optional)- What’s the second criteria to check in this range?

We can use multiple columns and criteria in this function, but be aware that range sizes should be the same for each range.

Examples from criteria to check:

“Apple” – Check how many cells contain the word “Apple

“>100” – Check how many cells contain a number greater than 100

Practice COUNTIFS function