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**