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

Use the COUNTA function to count cells containing data using Microsoft Excel

To count all cells that are not empty and contain data in a range or array, use the COUNTA function.

COUNTA(value1, value2, ...)

value1, value2, ...: 1 to 30 arguments representing the values to be counted.

To count all cells containing data:

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

Use the COUNTA function to count cells containing data

Note: The COUNTA function does not count empty cells.