Skip to content
Google Sheets

COUNTIF function in Google Sheets

Returns a conditional count across a range.

=COUNTIF(criteria_column, criterion)

COUNTIF syntax and parameters

Two arguments, two required.

  • criteria_columnrangeRequired

    The data column that is tested against `criterion`.

  • criterionanyRequired

    The pattern or test to apply to `column`.

COUNTIF examples

Formulas you'll actually reuse.

  1. How many orders came from the West region:

    =COUNTIF(A2:A200, "West")

    Result47

  2. Deals above the average — build the criterion with &:

    =COUNTIF(C2:C200, ">" & AVERAGE(C2:C200))

    Result68

COUNTIF in Excel

Same name — your formula ports as-is.

Try COUNTIF in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Google Sheets gets this done.