Menu
EXCEL COUNTIFS FUNCTION
Excel COUNTIFS Function Introduction
The COUNTIFS function applies criteria to cells in various ranges and counts how many times all criteria are fulfilled.
The number of rows and columns in each new range must be the same as in the criteria range1 parameter. The ranges do not have to be in close proximity to one another.
Description of Excel COUNTIFS Function
Syntax:
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
Parameter list:
- criteria range1 – the initial range to be evaluated.
- criteria1 – the criterion for the criteria range, such as 45, “>65,” B4, “Apple,” 5/3/2011, or “96.
- criterion range2, criterion2,…[Optional] additional ranges and criteria, with a total of 127 range/criteria pairs permitted.
Step By Step Guide of COUNTIFS Function
Example :
Key Points
- The number of rows and columns in each new range must be the same as in the criteria range1.
- In the criterion, you can use wildcard characters, question mark (?) (matches any single character), and asterisk (*) (matches any sequence of characters).
- Type a tilde (~) before the letter to find a real question mark or asterisk.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
