The COUNTIFS function counts the number of cells that contain numbers.
= COUNT(value1, [value2], …)
– Value 1 is required, which is the first cell to count;
– Value 2 is optional, which is the second cell to count.
The text that cannot be translated into numbers is not counted.
Example 1: Count the number of cells A2:A6
The result returns 0.
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
The result returns 5.
To count the number of cells with numbers in data range C2:C6, the result returns 5.