COUNTIF

Try it

When to use it

When should I use COUNTIF instead of SUMIF?

Use COUNTIF to count how many cells meet a condition; use SUMIF to add up the values of the cells that meet a condition.

How do I write the condition in COUNTIF?

Put the criteria in quotes, e.g. greater-than two as a quoted comparison, or a quoted word to count matching text.

Use cases

Count how many entries match a label

Count scores at or above a passing mark

Used in

operations

Syntax

COUNTIF(range, criterion)

Examples

=COUNTIF({10,25,30,15,22},">20") // => 3
=COUNTIF({"Paid","Unpaid","Paid","Pending"},"Paid") // => 2
=COUNTIF({"apple","application","banana","apricot"},"ap*") // => 3