Site icon ExcelNotes

How to Count Cells that Contain NO Text

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

Exit mobile version