Skip to content
Google Sheets

COUNTIFS function in Google Sheets

Returns the count of a range depending on multiple criteria.

=COUNTIFS(criteria_column1, criterion1, criteria_column2, criterion2)

COUNTIFS syntax and parameters

Four arguments, four required.

  • criteria_column1rangeRequired

    The data column to check against `criterion1`.

  • criterion1anyRequired

    The pattern or test to apply to `criteria_column1`.

  • criteria_column2rangeRequired

    Additional data column to check.

  • criterion2anyRequired

    Additional criteria to check.

COUNTIFS examples

Formulas you'll actually reuse.

  1. West deals over $1,000 — all conditions must hold:

    =COUNTIFS(A2:A200, "West", C2:C200, ">1000")

    Result22

  2. Orders dated in July 2026 — two conditions on the same column bound a range:

    =COUNTIFS(D2:D200, ">=" & DATE(2026, 7, 1), D2:D200, "<" & DATE(2026, 8, 1))

    Result31

COUNTIFS in Excel

Same name — your formula ports as-is.

Try COUNTIFS in the playground

Edit the example — nothing to install.

Preloaded with the COUNTIFS formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.