How to Count Cells that Contain Text

To count the number of cells that contain TEXT, you can use the COUNTIF function with wild card Asterisk (*).


=COUNTIF(Range, "*")


– The range is required, which will be the range of cells that you want to count;

– Asterisk (*) is required. Asterisk (*) is the wild card for text.


– The function will not count numbers or blank cells.

– Cells with SPACE only will be counted as text.

Example: To count how many cells that contain text in column A.

– Range: column A (A2:A8)

– Asterisk "*": wild card for text.

= Countif(A2:A8, "*")
There are 5 cells in column A that contain text.

Download Count Cells with Text

Leave a Reply