Returns a conditional count across a range.
To get an example spreadsheet and follow along with the video, click 'Make a copy' below.
Returns a conditional count of rows across a data column.
Sample usage
COUNTIF(table_name!score, “>90”)
Syntax
COUNTIF(criteria_column, criterion)
criteria_column
: The data column that is tested against 'criterion'.criterion
: The pattern or test to apply to 'column'.
Tip: Counting unique rows across multiple columns is not supported
Sample usage
COUNTIF(A1:A10,">20")
COUNTIF(A1:A10,"Paid")
Syntax
COUNTIF(range, criterion)
-
range
– The range that is tested againstcriterion
. -
criterion
– The pattern or test to apply torange
.-
If
range
contains text to check against,criterion
must be a string.criterion
can contain wildcards including?
to match any single character or*
to match zero or more contiguous characters. To match an actual question mark or asterisk, prefix the character with the tilde (~
) character (i.e.~?
and~*
). A string criterion must be enclosed in quotation marks. Each cell inrange
is then checked againstcriterion
for equality (or match, if wildcards are used). -
If
range
contains numbers to check against,criterion
may be either a string or a number. If a number is provided, each cell inrange
is checked for equality withcriterion
. Otherwise,criterion
may be a string containing a number (which also checks for equality), or a number prefixed with any of the following operators:=
,>
,>=
,<
, or<=
, which check whether the range cell is equal to, greater than, greater than or equal to, less than, or less than or equal to the criterion value, respectively.
-
Notes
COUNTIF
can only perform conditional counts with a single criterion. To use multiple criteria, useCOUNTIFS
or the database functionsDCOUNT
orDCOUNTA
.-
COUNTIF
is not case sensitive.
Examples
Make a copy
See also
COUNTIFS
: Returns the count of a range depending on multiple criteria.
SUMIF
: Returns a conditional sum across a range.
DCOUNTA
: Counts values, including text, selected from a database table-like array or range using a SQL-like query.
DCOUNT
: Counts numerical values selected from a database table-like array or range using an SQL-like query.
COUNTUNIQUE
: Counts the number of unique values in a list of specified values and ranges.
COUNTA
: Returns the number of values in a data set.
COUNTBLANK
: Returns the number of empty cells in a given range.
COUNT
: Returns the number of numeric values in a data set.