countifs
Count cells meeting multiple criteria.
Syntax
Section titled “Syntax”v = countifs(criteria_range1, criteria1, criteria_range2, criteria2, ...)Description
Section titled “Description”Counts cells where every criteria_range_n matches its corresponding criteria_n. Multiple criteria are combined with logical AND.
Example
Section titled “Example”countifs(A1:A100, '>0', B1:B100, 'red')See also
Section titled “See also”countif— Count cells in a range that meet a criterion.averageifs— Mean of numbers meeting multiple criteria.sumifs— Sum cells meeting multiple criteria.