COUNTIFS

Returns the count of criteria_ranges based on the given criterions.

Syntax

COUNTIFS(count_range, criteria_1, [count_range_n], [criteria_n])

Arguments

Argument	Description	Required
count_range	The range to check against criteria1.	Required
criteria_1	The criteria is the formula that has access to the special CELL keyword. The formula will be evaluated for each cell in the range.	Required
count_range_n	Additional range checked against additional criteria.	Optional
criteria_n	Additional criteria range that will be evaluated.	Optional

Examples

Count cells meeting single criteria

Count cells meeting multiple criteria

Count with numeric criteria

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.
• COUNTIF - Returns the count of cells that meet a specified criteria
• 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
• MODE - Returns the most frequently occurring value in a data set
• PERCENTILE - Returns the k-th percentile of values in a range
• 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

---

← Back to Formula Reference