Hello Excellers, welcome to another #Exceltips blog post in my 2021 series. recently I have been counting cells with text in my Excel worksheet. So, I thought it would be a great Excel tip to share.
So, do you need to count how many cells that contain text?. I have used this technique to how many rows in my Excel data set contain any text. For example, the text references in my data represent a particular type of customer, which I can easily count with the formula COUNTIF and a wildcard!
So, here is a speedy way to count how many of your cells contain text. (That is not numbers, not errors, not blanks).
Let’s work through an extract of my data set.
I want to see how many of my customers have text in their customer_id. The syntax of the COUNTIF formula is
=COUNTIF(range, criteria)
Where
range= the range of cells from which you want to count non blank cells
criteria = the condition, i.e a number, expression or text that determines which cells should be counted.
We can use the wildcard * as the criteria argument in our formula, to search for ANY text in our customer_id data range. The wildcard is surrounded by quotation marks (” “).
Excel has correctly identified that I have 2 customers in my list that contain some type of text characters. Job Done!. Easy as that. A simple way of counting cells with text in Excel.