Description
Counts the number of cells in a range that contain numeric values.
NOTES
- Only cells containing numbers are counted.
- Empty cells, text, logical values, and error values are ignored.
- Dates and times are counted because they are stored as numeric values in Excel.
- If no numeric values are found, the function returns
0.
Syntax
Copied!=COUNT(value1, [value2], ...)
SAMPLE-1
EXAMPLE 1.1
Copied!=COUNT(A2:A10)