The best formulas to count cells with text is COUNTIF with a wildcard character (* – Asterisk). COUNTIF with Wildcard Characters to Count Cell with Text Values So today in this post, I’d like to share 6 different ways to count cells with text in different situations. One thing which you need to understand here is that cells with text mean all the cells where you don’t have numbers, blank cells, or errors. I believe that it depends on the situation. But the point is which one you should use. In Excel, you have different formulas to count all the cells where you have text values. Actually, he was trying to figure out which is the best method to use.īut if you think for a second. Last week one of my readers asked me for a simple formula which he can use to count cells with text.
