=FUNCTIONS

COUNTIFS()

Statistical

Counts cells that meet multiple conditions at once.

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)

COUNTIFS extends COUNTIF to any number of conditions, all of which must be true for a row to be counted — the same AND logic as SUMIFS.

Every criteria_range must be the same size and shape, or COUNTIFS returns a #VALUE! error.

Arguments

criteria_range1: The first range to test.
criteria1: The condition for criteria_range1.
criteria_range2, criteria2, ...optional: Additional range/condition pairs — all must match.

=COUNTIFS(A2:A200, "North", B2:B200, "2026")

→14

Counts rows where region is North AND year is 2026.