COUNTIF

Returns the count of cells that meet a specified criteria

Syntax

COUNTIF(range, criteria)

Arguments

Argument Description Required
range The range of cells to count Required
criteria The criteria to count cells by Required

Examples

Count cells greater than or equal to 90

=COUNTIF(A1:A6, CELL >= 90)

Result ⇒ 3
A
1 89
2 93
3 96
4 85
5 91
6 88

Count cells equal to specific text

=COUNTIF(A1:A4, CELL = "Yes")

Result ⇒ 2
A
1 Yes
2 No
3 Yes
4 Maybe

Count cells less than a value

=COUNTIF(A1:A4, CELL < 15)

Result ⇒ 2
A
1 10
2 20
3 30
4 5

Related Functions

Other Statistical functions:

  • AVEDEV - Returns the average of the absolute deviations of data points from their mean
  • AVERAGE - Returns the average of given arguments. Text is ignored.
  • CORREL - Returns the correlation coefficient between two data sets
  • COUNT - Returns the count of numeric values in a dataset.
  • COUNTA - Returns the count of values in a list of arguments including text, logical values, error values, and empty text.
  • COUNTIFS - Returns the count of criteria_ranges based on the given criterions.
  • FORECAST - Calculates, or predicts, a future value by using existing values
  • LARGE - Returns the k-th largest value in a data set
  • MAX - Returns the largest number from the provided arguments
  • MEDIAN - Returns the median of the given numbers
  • MIN - Returns the smallest number from the provided arguments
  • MINIFS - Returns the minimum value from a range that meets multiple criteria.
  • MODE - Returns the most frequently occurring value in a data set
  • PERCENTILE - Returns the k-th percentile of values in a range
  • PERCENTRANK - Returns the rank of a value in a dataset as a percentage (0 to 1) of the dataset
  • RANK - Returns the rank of a number from the list of other numeric values
  • SMALL - Returns the k-th smallest value in a data set
  • STDEV - Returns the estimated standard deviation based on a sample
  • STDEVP - Calculates standard deviation based on the entire population
  • SUMIF - Returns the sum of a range depending on criteria
  • SUMPRODUCT - Returns the sum of products for a list of arguments
  • VAR - Returns the estimated variance for a sample of data
  • VARP - Calculates variance based on the entire population