How to use COUNTIFS Function in Excel

How to use COUNTIFS Function in Excel2018-11-16T10:06:06+00:00

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.

Important Points

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”.

Multiple Criteria Cells Count With Excel COUNTIFS Function
Using Wildcard Characters With Excel COUNTIFS Function

Content Protection by DMCA.com