Excel COUNTIFS Function

This function is a part of ExcelChamp's Top 100 Excel Functions.

Quick Intro

Excel COUNTIFS Function helps you to count cells which meets multiple criteria.

That means you can get the count of cells where the values you specified is there.

Let's understand it's syntax.

Syntax

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

1. criteria_range1 – The range of cells which you want to evaluate using criteria1.
2. criteria1 – The criteria which you want to evaluate for criteria_range1.
3. [criteria_range2] – The range of cells which you want to evaluate using criteria1.
4. [criteria2] – The criteria which you want to evaluate for criteria_range1.

Further you'll learn some real life examples but before that you need to note some important points about COUNTIFS.

Examples

In the below example, we have used COUNTIFS to count females whose are above 25 years.

And we have specified two criteria for evaluation, one is “Female” and other is a greater than operator to count cells with a number which is greater than “>25”.