COUNT Function - Excel


Overview


The COUNT function in Excel is a useful tool for counting the number of cells in a range that contain numeric values. This function excludes cells that are blank, contain text, or contain errors.

An example of the COUNT function in Excel

Example:

=COUNT(C2:C11)

Syntax:

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

value1: The first value or range of cells to count.

[value2], ...: Additional values or ranges to include in the count. You can include up to 255 arguments.


Example


In the example above, the COUNT function returns a 7 because that is how many number values there are in the range C2:C11.


Interactive GSheet