COUNTIFS

Counts cells that meet multiple conditions across several ranges.

Syntax

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …)

Arguments

criteria_range1 - The first range to test.
criteria1 - The condition applied to the first range.

Examples

=COUNTIFS(A2:A50, "West", B2:B50, ">100")

Returns: Rows where A is West AND B > 100

Every pair must match for the row to be counted.

Common Errors and Gotchas

All ranges must be the same length.
Each condition needs its own range/criteria pair.

Does COUNTIFS Work in Google Sheets?

Yes. COUNTIFS uses the same syntax in Google Sheets and LibreOffice Calc, so you can paste these formulas straight across.

See Also