# The Excel function: COUNTIF

Counts the number of cells within a range that meet the given criteria.

More information: support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34

Other functions

Returns the average of the absolute deviations of data points from their mean

Returns the average of its arguments

Returns the average of its arguments, including numbers, text, and logical values

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria

Returns the average (arithmetic mean) of all cells that meet multiple criteria

Returns the beta cumulative distribution function

Returns the inverse of the cumulative distribution function for a specified beta distribution

Returns the individual term binomial distribution probability

Returns the probability of a trial result using a binomial distribution

Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value

Returns the cumulative beta probability density function

Returns the one-tailed probability of the chi-squared distribution

Returns the cumulative beta probability density function

Returns the inverse of the one-tailed probability of the chi-squared distribution

Returns the test for independence

Returns the confidence interval for a population mean

Returns the confidence interval for a population mean, using a Student's t distribution

Returns the correlation coefficient between two data sets

Counts how many numbers are in the list of arguments

Counts how many values are in the list of arguments

Counts the number of blank cells within a range

Counts the number of cells within a range that meet multiple criteria

Returns covariance, the average of the products of paired deviations

Returns the sample covariance, the average of the products deviations for each data point pair in two data sets

Returns the sum of squares of deviations

Returns the exponential distribution

Returns the F probability distribution

Returns the F probability distribution

Returns the inverse of the F probability distribution

Returns the inverse of the F probability distribution

Returns the result of an F-test

Returns the inverse of the F probability distribution

Returns the Fisher transformation

Returns the inverse of the Fisher transformation

Returns a value along a linear trend

Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm

Returns a confidence interval for the forecast value at the specified target date

Returns the length of the repetitive pattern Excel detects for the specified time series

Returns a statistical value as a result of time series forecasting

Returns a future value based on existing values

Returns a frequency distribution as a vertical array

Returns the Gamma function value

Returns the gamma distribution

Returns the inverse of the gamma cumulative distribution

Returns the natural logarithm of the gamma function, Γ(x)

Returns the natural logarithm of the gamma function, Γ(x)

Returns 05 less than the standard normal cumulative distribution

Returns the geometric mean

Returns values along an exponential trend

Returns the harmonic mean

Returns the hypergeometric distribution

Returns the intercept of the linear regression line

Returns the kurtosis of a data set

Returns the k-th largest value in a data set

Returns the parameters of a linear trend

Returns the parameters of an exponential trend

Returns the cumulative lognormal distribution

Returns the inverse of the lognormal cumulative distribution

Returns the maximum value in a list of arguments

Returns the maximum value in a list of arguments, including numbers, text, and logical values

Returns the maximum value among cells specified by a given set of conditions or criteria

Returns the median of the given numbers

Returns the minimum value in a list of arguments

Returns the smallest value in a list of arguments, including numbers, text, and logical values

Returns the minimum value among cells specified by a given set of conditions or criteria

Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data

Returns the most common value in a data set

Returns the negative binomial distribution

Returns the normal cumulative distribution

Returns the standard normal cumulative distribution

Returns the inverse of the standard normal cumulative distribution

Returns the inverse of the normal cumulative distribution

Returns the Pearson product moment correlation coefficient

Returns the k-th percentile of values in a range, where k is in the range 01, exclusive

Returns the k-th percentile of values in a range

Returns the rank of a value in a data set as a percentage (01, exclusive) of the data set

Returns the percentage rank of a value in a data set

Returns the number of permutations for a given number of objects