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