As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Count Cells with Text in Excel: A Step-by-Step Guide

If you work with data in Excel, you may find yourself in a situation where you need to count the number of cells that contain text (i.e. not numbers, not errors, not blank cells). The good news is that there is a simple formula that you can use to count cells with text in Excel. In this article, we'll show you how to use this formula, step-by-step.

Step 1: Enter the Formula

The first thing you need to do is enter the following formula into a blank cell:

=COUNTIF(range,"?*")

In this formula:

  • "range" is the cells that you want to count.
  • "?*" is a wildcard that will match any character.

Step 2: Select the Range of Cells to Count

Now that you have the formula entered, you need to select the range of cells that you want to count. To do this, simply click and drag your mouse over the cells that you want to include in the range.

Step 3: Press Enter

Once you have the formula and the range of cells selected, simply press Enter on your keyboard, and the formula will calculate the number of cells that contain text.

This simple COUNTIF formula with the wildcard "?*" allows you to quickly count the number of cells containing text in a specified range, making data analysis and organization in Excel more efficient.