Returns a conditional count across a range.
range– The range that is tested against criterion.
criterion– The pattern or test to apply to range.
rangecontains 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.
~*). A string criterion must be enclosed in quotation marks. Each cell in
rangeis then checked against
criterionfor equality (or match, if wildcards are used).
rangecontains numbers to check against, criterion may be either a string or a number. If a number is provided, each cell in
rangeis checked for equality with
criterionmay be a string containing a number – which also checks for equality – or a number prefixed with any of the following operators:
<=, 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.
COUNTIFcan only perform conditional counts with a single criterion. To use multiple criteria, use
COUNTIFSor the database functions
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.