How to Count Cells that Contain NO Text

To count the number of cells that contain no text, you can use the COUNTIF function.


=COUNTIF(Range, "<>*")


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

– Not equal to (<>) and Asterisk (*) are both required. Asterisk (*) is the wild card for text.


The function will count all cells that contain no TEXT. A cell with only SPACE will be counted as text.

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

– Range: column A (A2:A8)

– Asterisk "*": wild card for text.

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

Download Example: Cells with NO Text

Leave a Reply