What is COUNTIFS?
Counts cells meeting multiple criteria. Perfect for complex counting scenarios with multiple conditions applied simultaneously.
Syntax
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Example
Formula: =COUNTIFS(A2:A10, \
Result: 3
How It Works
Counts rows where A2:A10 equals 'East' AND B2:B10 is greater than 50. All conditions must be met. Supports up to 127 criteria range/criteria pairs.