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

Data Analysis

  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Conditional Formatting Rules in Excel
  • How To Create Pareto Chart in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • Move chart to a separate worksheet in Excel

References

  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Create hyperlink with VLOOKUP in Excel
  • How to get first column number in range in Excel
  • Approximate match with multiple criteria in Excel
  • Lookup entire row in Excel

Data Validations

  • Excel Data validation allow uppercase only
  • Excel Data validation must contain specific text
  • Excel Data validation whole percentage only
  • Excel Data validation no punctuation
  • Data validation must not exist in list

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

  • How to use IFS function in Excel
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel TRUE Function
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • FALSE function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Calculate time difference in hours as decimal value in Excel
  • NETWORKDAYS.INTL function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate percent of year complete in Excel
  • Get first day of previous month in Excel
  • Count day of week between dates in Excel

Grouping

  • How to randomly assign people to groups in Excel
  • Map inputs to arbitrary values in Excel
  • Group times into 3 hour buckets in Excel
  • Group numbers with VLOOKUP in Excel
  • Group arbitrary text values in Excel

General

  • Excel Default Templates
  • Subtotal by invoice number in Excel
  • Customize Ribbon In Excel
  • Convert column letter to number in Excel
  • How to generate random number between two numbers in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning