Count only Text Entries in any Excel Range

Problem in Hand: We want to count only the text entries in the list under consideration. Meaning we want to ignore all possible entries under sun in an excel cell except “Text”. Image below will help you understand problem visually.

Count only Text Entries

To solve this problem I have used function COUNTIF. The formula used is E2: =COUNTIF(B3:B11,”*”). Based on the data above, it has given 4 as a result. Image below is the demonstration of the same.

Count only Text Entries2

Thank for your time and “HAPPY LEARNING” 🙂

Show Comments

No Responses Yet

Leave a Reply