Excel formula: Count cells that contain text | Exceljet

COUNTIF counts the number of cells that match the supplied criteria. In this case, the criteria is supplied as the wildcard character "*" which matches any number of text characters.

Summary To count cells in a range that contain text values , you can use the COUNTIF function and the asterisk (*) wildcard . In the example shown, the formula in cell H5 is: =COUNTIF(data,"*") where data is the named range B5:B15. The result is 4 because four cells in the range B5:B15 contain text values. Related formulas: Count cells with specific text , Count cells that are not empty . Generic formula =COUNTIF(range,"*") Explanation In this example, the goal is to count cells in a range that contain text values. This could be hard-coded text like "apple" or "red", numbers en

related reading

• If cell is not blank - Excel formula | Exceljetexceljet.net
• Use conditional formatting rules in Google Sheets - Computer - Google Docs Editors Helpsupport.google.com
• Comparison Operators in Google Sheets and Equivalent Functionsinfoinspired.com
• AVERAGE - Google Docs Editors Helpsupport.google.com
• Elicit: AI for scientific researchelicit.org
• Elicit: AI for scientific researchelicit.com
• Paradigm - Scale Agentic Researchparadigmai.com
• Write DAX formulas - Training | Microsoft Learndocs.microsoft.com
• Overview of Cell Counting Methods – Manual & Automatedlogosbio.com
• Sturdy Statisticssturdystatistics.com
• Arc Institute’s first virtual cell model: <span style="font-variant: small-caps">S<span style="font-weight: bolder">tate</span></span> | Arc Institutearcinstitute.org
• HackerRank - Online Coding Tests and Technical Interviewshackerrank.com