All functions / Statistics
COUNTIFS
Counts the rows that meet every one of several conditions.
Syntax
=COUNTIFS(criteria_range, criteria, [criteria_range1, [criteria_range2], …])
Arguments
criteria_range: A range to test.criteria: The condition for that range.criteria_range(optional): More range/condition pairs.
Example
=COUNTIFS(B2:B20, "East", C2:C20, ">100") → East orders over 100