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

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

To count all cells that contain text data, use a combination of functions in one formula. The number of cells with any kind of data is counted with the COUNTA function. All numeric cells are counted with the COUNT function. Just subtract the results of the COUNT function from the results of the COUNTA function, using the same range, to get all cells containing text.

To count only cells with text:

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)-COUNT(A1:A10).
3. Press <-Enter->.

Use the COUNTA function to count cells containing text

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.