How to Use COUNT function

The COUNT function counts the number of cells that contain numbers.

Formula:

= COUNT(value1, [value2], …)

Explanations:

- Value 1 is required, which is the first cell to count;
- Value 2 is optional, which is the second cell to count.

Cautions:

The text that cannot be translated into numbers is not counted.

Example 1: Count the number of cells A2:A6

=COUNT(A2:A6)

To count the number of cells A2:A6, the result returns 0. There is no cell containing numbers in the data range A2:A6.

Example 2: Count the number of cells C2:C6

=COUNT(C2:C6)

To count the number of cells with numbers in data range C2:C6, the result returns 5.

Download COUNT function

Leave a Reply