Use the COUNT function to count cells containing numeric data - Basic Statistical Functions - Microsoft Excel Tutorials

Use the COUNT function to count cells containing numeric data using Microsoft Excel

To count all cells that contain numbers, use the COUNT function. Empty cells, logical values, text, and error values are ignored.

COUNT(value1, value2, ...)

value1, value2, ...: From 1 to 30 arguments of any type of data.  However, all but numeric data is ignored.

To count the number of cells that contain numbers:

1. In cells A1:A10 type data (numeric and text).
2. Select cell C1 and type the following formula: =COUNT(A1:A10).
3. Press <-Enter->.

Use the COUNT function to count cells containing numeric data

Note: Arguments that are date and time values are counted as numeric too.