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.
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.
Thank for your time and “HAPPY LEARNING” 🙂