## 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]…)

**criteria_range1**– The range of cells which you want to evaluate using criteria1.**criteria1**– The criteria which you want to evaluate for criteria_range1.**[criteria_range2]**– The range of cells which you want to evaluate using criteria1.**[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

- All criteria ranges must have the same number of rows. (For example, if criteria_range1 has 10 rows then criteria_range2 must have 10 rows.)
- You can use a text, a number, a cell reference, or a formula as a criteria.
- You can evaluate up to 127 criteria ranges.
- Criteria which is a text or a logical operator should be enclosed in double quotes.
- You can also use wildcard characters with this.
- If criteria is a reference to a cell which is empty, the function will treat it as 0.
- It's not a case sensitive function.

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

In the below example, we have used an asterisk in one criterion and greater than operator in another one to count the number of the person whose name is starting with alphabet A and whose age is more than 25.

Related Functions

- COUNT Function: It returns the count of those cells from a range which have a numeric value [...]
- COUNTA Function: It counts all the cells which are not empty. It doesn't matter which type of value is there in a cell, it counts all the cell with values in it [...]
- COUNTBLANK Function: It counts all the cells which are empty/blank, but if a cell has a blank space it will not count it [...]
- COUNTIF Function: It counts the number of cells which meet a criterion. You need to specify a criterion and a range of cell to check that criterion [...].

Related Tips

- Count Cells with Text: In Excel, we have different formulas which we can use to count all the cells where we have text values. But the point is [...]
- Count Words in Excel: When it comes to Excel there is no such option to count words. But [...]
- Count Unique Values: In Excel, you can use different methods to get a count of unique values. It depends that which type of values you have so that [...]
- COUNTIF OR: Normally, when we COUNTIF we can just count cells by specifying a single condition and with COUNIFS we can specify [...]