Hola, iam Dana Demme, G’day, mate.

How Do I Count Cells In Excel Without Text? [Solved]

In a blank cell enter the formula =COUNTIF(A1:A40,"<>count") and then press the Enter key. Then you will get the number of cells which don’t contain the specific text of “count” in the specific Range A1:A40.

Count Cells That Only Contain Text in Microsoft Excel

This

Mysterious Excel Formula Syntax to Count Text Cells (as NEVER Seen Before)

It’s safe to say this

How to Count the Occurrences of a Number or Text in a Range in Excel : Using Excel

Counting