You can use the COUNTIF function to count the cells containing no text.
Example: You are working on a database with the first name in column A, the last name in column B, and the salaries in column C.
Formula 1: How many cells contain no text in column A?
= Countif(A2:A8, "<>*")
The wild card asterisk (*) is used in the formula representing text. There are two cells: A5 and A8.
Formula 2: How many cells are not the text in columns A and B?
= Countif(A2:B8, "<>*")
The wild card asterisk (*) is used in the formula representing text. Two cells in columns A and B are not text, and cell A9 (in orange) has one space, which counts as text.
Note: The COUNTIF function
Formula:
=COUNTIF(Range, "<>*")
Explanations:
– The range is required, which will be the range of cells that you want to count;
– The asterisk (*) is the wild card for text.
Practice: Cells with NO Text