To count the number of cells that contain no text, you can use the COUNTIF function.
– 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.