## How to use the COUNT function

*Article updated on March 29, 2018*

The COUNT function counts all numerical values in an argument, it allows you to have up to 255 arguments.

Blank cells, boolean values and text values are not counted. It differs from most other functions, ignoring error values.

Formula in cell D3:

=COUNT(B3:B8)

### Excel Function Syntax

=COUNT(*value1, [value2], ...*)

### Arguments

value1 |
Required. A cell reference, array or constants for which you want to count numbers. |

[value2] |
Optional. Up to 255 additional arguments. |

### Articles with the 'COUNT' Function

The following 6 articles have formulas that contain the COUNT function.

Create dependent drop down lists containing unique distinct values

This article explains how to build dependent drop down lists. Here is a list of order numbers and products. We […]
This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are […]

I read an interesting blog post Is A Particular Word Contained In A Text String? on Spreadsheetpage. That inspired me […]

Pamela asks: I would like to ask you how to identify PAIR of same numbers, but with a different sign. […]

The array formula in cell C3 checks if text string in B3 contains all values in F2:F3. Share this article […]

Count the number of times a specific number exists in a list

Question: How many times is the value 3 (B2) in this list (A:A)? Answer: =COUNT(SEARCH(B2,A:A)) + CTRL+ SHIFT + ENTER […]### Functions in 'Statistical'

The COUNT function function is one of many functions in the 'Statistical' category.

The AVEDEV function calculates the average of the absolute deviations of data points from their mean. The absolute deviation from the […]

Calculates the average of numbers in a cell range. In other words, the sum of a group of numbers and […]

The AVERAGEA function returns the average of a group of values. Text and boolean value FALSE evaluates to 0. TRUE to […]

The AVERAGEIF function returns the average of cell values that are valid for a given condition. Formula in cell D3: […]

The AVERAGEIFS function returns the average of cell values that evaluates to TRUE for multiple criteria. Formula in cell F6: =AVERAGEIFS(D3:D8,B3:B8,F3,C3:C8,G3) […]

The CORREL function calculates the correlation between two groups of numbers. Formula in cell B12: =CORREL(C3:C9, D3:D9) The value in cell […]

The COUNT function counts all numerical values in an argument, it allows you to have up to 255 arguments. Blank […]

The COUNTA function counts the non-empty or blank cells in a cell reference. The picture above demonstrates the COUNTA function […]

The COUNTBLANK function counts empty or blank cells in a range. The picture above demonstrates the COUNTBLANK function entered in […]

Counts the number of cells that meet a specific condition.

Checks multiple conditions against the same number of cell ranges and counts how many times all criteria are met.

The EXPON.DIST function returns the exponential distribution. Use EXPON.DIST to model the time between events. Formula in cell C3: =EXPON.DIST(B3,C3,D3) […]

The FORECAST.LINEAR function calculates a value based on existing x and y values using linear regression. Use this function to […]

Returns how many times values exist in a given range. Note, this function returns an array of values.

The LARGE function calculates the k-th largest value from an array of numbers. Use the LARGE function, for example, to extract […]

The MAX function allows you to calculate the largest number in a cell range. The formula in cell D3 extracts […]

The MAXIFS function allows you to calculate the highest value based on a condition or criteria. Formula in cell G4: […]

The MEDIAN function calculates the median based on a group of numbers. The median is the middle number of a […]

The MIN function allows you to retrieve the smallest number in a cell range. The formula in cell D3 extracts […]

The MINA function returns the smallest number. Text values and blanks are ignored, boolean value TRUE evaluates to 1 and FALSE […]

The MINIFS function calculates the smallest value based on a given set of criteria. Formula in cell E3: =MINIFS(C3:C10,B3:B10,"A") The […]

The MODE.MULT function calculates the most frequent number in a cell range. It will return multiple numbers if they are equally […]

The NORM.DIST function calculates the normal distribution for a given mean and standard deviation. Formula in cell C7: =NORM.DIST(C2,C3,C4,C5) Excel […]

The NORM.INV function calculates the inverse of the normal cumulative distribution for a given mean and standard deviation. Formula in […]

The PERMUT function returns the number of permutations for a set of elements that can be selected from a larger […]

The PERMUTATIONA function returns the number of permutations for a specific number of elements that can be selected from a […]

The QUARTILE.INC function returns the quartile of a data set, based on percentile values from 0..1, inclusive. Use the Quartiles.inc […]

The RANK.AVG function returns the rank of a number in a list of numbers. The number returned indicates its size […]

The SMALL function lets you extract a number in a cell range based on how small it is compared to the other numbers in the group.

The STANDARDIZE function calculates a normalized value from a distribution characterized by mean and standard_dev. Formula in cell C5: =STANDARDIZE(C2, […]

The STDEV.P function returns standard deviation based on the entire population. The standard deviation is how widely numbers are distributed […]

The STDEV.S function returns standard deviation based on a sample of the entire population. The standard deviation is how widely […]

The STDEVA function estimates the standard deviation from a sample of values. Standard deviation shows how much the values differ […]

The STDEVPA function returns the standard deviation based on the entire population, including text and logical values. The standard deviation […]

The TREND function calculates values along a linear trend. Fits a straight line (using the method of least squares) to […]

The TRIMMEAN function calculates the mean of the interior of a data set. The function excludes a percentage of data […]

The VAR.P function returns the variance based on the entire population. The function ignores logical and text values. Variance shows […]

The VAR.S function tries to estimate the variance based on a sample of the population. The function ignores logical and […]