COUNTIFS(...)
How to countif with and condition
Used Functions
Category: Statistical
Counts the number of cells within a range that meet multiple criteria
Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
Practice COUNTIFS Formula at Sheetzoom
COUNTIFS formula at Microsoft help
0
We use multiple criteria to emulate the AND condition with COUNTIFS to reach the desired result. The COUNTIFS function takes multiple criteria and multiple ranges to get to the final count by using logical operators to build the criteria.