How to Count Cells with Text in Excel

Feb 23, 2020 • edited Feb 24, 2020

How to Count Cells with Text in Excel

Count Cells with Text

Excel contains several functions to help you count the number of cells in a range that are blank or contain certain types of data.


This page illustrates multiple ways to count cells with text in Excel. Visit our page about the COUNTIF function to count cells that contain specific text.

1a. Use the COUNTIF function and the asterisk symbol (*) to count cells with text.

1b. You can also create an array formula to count cells with text.

Array FormulaArray Formula

Note: visit our page about array formulas to learn more about single cell array formulas.

1c. You can also use the SUMPRODUCT function to count cells with text.

Note: visit our page about the SUMPRODUCT function to learn more about this function.

2a. Numbers, Booleans (TRUE or FALSE), blanks and errors are not counted as text.

2b. The formula below counts cells with text and counts cells with Booleans.

3a. Enter a space into cell A4. The COUNTIF function at step 1a and step 2a also counts cells with a space character.

3b. The COUNTIFS function below counts cells with text and excludes cells with a space character.

Note: the COUNTIFS function in Excel counts cells based on two or more criteria.

#Tutorial#How To#Functions

How to Use the SUM function in Excel to sum a range of cells

How to Count Cells with Text in Excel