How to Count Cells that Contain NO Text

To count the number of cells that are text, please check here. If you count the cells that contain no text, you can use the COUNTIF function.

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: To count how many cells that contain no text in column A.

= Countif(A2:A8, "<>*")

The wild card asterisk (*) is used in the formula and it represents all the text. There are two cells in column A: A5 and A8.

Formula 2: To count how many cells that are not the text in column A and column B.

= Countif(A2:B8, "<>*")

The wild card asterisk (*) is used in the formula and it represents all the text. Two cells in column A and column B are not text. Cell A9 (in orange) has one space, so it 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

Leave a Reply