Skip to main content

COUNTIF

Definition of COUNTIF

Returns a conditional count across a range.

Sample Usage

COUNTIF(A1:A10,">20")

COUNTIF(A1:A10,"Paid")

Syntax

COUNTIF(range, criterion)

  • range - The range that is tested against criterion.

  • criterion - The pattern or test to apply to range.

    • 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 in range 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 in range is checked for equality with criterion. Otherwise, criterionmay 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, use COUNTIFS or the database functions DCOUNT or DCOUNTA.

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 numeric values selected from a database table-like array or range using a SQL-like query.

COUNTUNIQUE: Counts the number of unique values in a list of specified values and ranges.

COUNTA: Returns a count of the number of values in a dataset.

COUNTBLANK: Returns the number of empty cells in a given range.

COUNT: Returns a count of the number of numeric values in a dataset.

To use the COUNTIF Formula, simply begin with your edited Excellentable:

Then begin typing the COUNTIF formula in the area you would like to display the outcome: 

By selecting the range of cells and entering the criteria you would like to calculate the COUNTIF formula, Excellentable generates the outcome:

 

Error.

User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.