When to use Excel COUNTIFS Function
COUNTIFS function can be used when you want to count the number of cells that meet a single or multiple criteria.
What it Returns
It returns a number that represents the number of cells that met a specified criteria in the specified range(s).
Syntax
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
Input Arguments
criteria_range1 – The range of cells for which you want to evaluate against criteria1. criteria1 – the criteria which you want to evaluate for criteria_range1 to determine which cells to count. [criteria_range2] – The range of cells for which you want to evaluate against criteria2. [criteria2] – the criteria which you want to evaluate for criteria_range2 to determine which cells to count.
Additional Notes
Criteria could be a number, expression, cell reference, text, or a formula. Criteria which are text or mathematical/logical symbols (such as =,+,-,/,) should be in double quotes. Wildcard characters can be used in criteria. There are three wildcard characters in Excel – the question mark (?), asterisk (), and tilde (~) A question mark matches any single character An asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character. Criteria are case insensitive (“Hello” and “hello” are treated as same). Cells in counted only when all the conditions are met. Up to 127 pairs to criteria and criteria range are allowed. If the criteria argument is a reference to an empty cell, the COUNTIFS function treats the empty cell as a 0 value
Excel COUNTIFS Function – Live Example
Excel COUNTIFS Function – Video Tutorial
Related Excel Functions:
Excel COUNT Function. Excel COUNTA Function. Excel COUNTBLANK Function. Excel COUNTIF Function.
Using Multiple Criteria in Excel COUNTIF and COUNTIFS Function How to Count Cells that Contain Text Strings.