What is the use of Excel COUNTIFS Function?
Use Excel COUNTIFS Function to count cells which meet multiple criteria. In simple words, you can check how many cells are there in a range that meet multiple criteria that you have specified.
Syntax for Excel COUNTIFS Function
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
criteria_range1 – The range of cells which you want to evaluate using criteria1. [Required]
criteria1 – The criteria which you want to evaluate for criteria_range1. [Required]
criteria_range2 – The range of cells which you want to evaluate using criteria1. [Optional]
criteria2 – The criteria which you want to evaluate for criteria_range1. [Optional]
More Information on Excel COUNTIFS Function
- 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 in criteria.
- You can evaluate up to 127 criteria ranges using COUNTIFS Function.
- Criteria which is a text or a logical operator should be enclosed in double quotes.
- You can also use wildcard characters in COUNTIFS Function.
- If criteria is a reference to a cell which is empty, the function will treat it as 0.
- COUNTIFS is not case sensitive.
Examples to understand Excel COUNTIFS Function
In below example, I have used COUNTIFS to count females who are above 25 years age. I have specified two criteria for evaluation, one is female and in other criteria, I have used a greater than operator to count cells with a number which have a value which is greater than 25.
In below example, I have used the asterisk in one criteria 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.
Download Sample File
Use Excel COUNTIFS Function to count cells which meet multiple criteria. learn more about how to use excel countifs function from here.