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.
