Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Error Bars in Excel
  • Understanding Pivot Tables in Excel
  • How to count table columns in Excel
  • Filter Data Based on Date in Excel
  • Conditional Formatting Data bars Examples in Excel

References

  • Create hyperlink with VLOOKUP in Excel
  • Count rows with at least n matching values
  • How to get last row in text data in Excel
  • How to reference named range different sheet in Excel
  • How to use Excel TRANSPOSE Function

Data Validations

  • Excel Data validation unique values only
  • Excel Data validation must contain specific text
  • Excel Data validation don’t exceed total
  • How To Create Drop-down List in Excel
  • Excel Data validation only dates between

Count cells that contain text in Excel

by

This tutorial shows how to Count cells that contain text in Excel using the example below;

Formula

=COUNTIF(range,"*")

Explanation

To count the number of cells that contain text (i.e. not numbers, not errors, not blank), use the COUNTIF function and a wildcard.

“*” is a wildcard matching any number of characters.

Do you want to count cells that contain specific text? See this formula instead.

In the example, the active cell contains this formula:

=COUNTIF(B4:B8,"*")

How this formula works

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.

A few notes:

  • The logical values TRUE and FALSE are not counted as text
  • Numbers are not counted by “*” unless they are entered as text
  • A blank cell that begins with an apostrophe (‘) will be counted.

COUNTIFS solution

If you need to restrict counts to meet more specific criteria, you can switch to the COUNTIFs function. For example, to count cells with text, but exclude cells with only a space character, you could use:

=COUNTIFS(range,"*",range,"<> ")

SUMPRODUCT solution

You can also use SUMPRODUCT to count text values along with the function ISTEXT like so:

=SUMPRODUCT(--ISTEXT(range))

The double hyphen (called a double unary) coerces the result of ISTEXT from a logical value of TRUE or FALSE, to 1’s and 0’s. SUMPRODUCT then returns the sum of ones and zeros.

Post navigation

Previous Post:

How to use Excel CHOOSE Function

Next Post:

Customize Ribbon In Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • OR function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel XOR Function
  • IFS function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Get days between dates in Excel
  • YEAR function: Description, Usage, Syntax, Examples and Explanation
  • WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation
  • WORKDAY function: Description, Usage, Syntax, Examples and Explanation
  • Count holidays between two dates in Excel

Grouping

  • Group numbers with VLOOKUP in Excel
  • If cell contains one of many things in Excel
  • How to randomly assign people to groups in Excel
  • Categorize text with keywords in Excel
  • How to randomly assign data to groups in Excel

General

  • Spell Check in Excel
  • Find, Trace and Correct Errors in Excel Formulas using ‘Formula Auditing’
  • How to calculate decrease by percentage in Excel
  • Count cells that contain errors in Excel
  • Advanced Number Formats in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning