spot_img

How to Count Cells with Text in Excel?

Spreadsheet software, such as Microsoft Excel and Google Sheets, is ideal for data manipulation. These applications seem to have an infinite number of options for modifying, organizing, and filtering through data. You may ultimately need to run a data query to count the number of cells that contain text. It is feasible to determine how many cells in a data collection include text if the cells contain a combination of numbers and letters.

In the tutorial below, we’ll teach you how to count cells with text in Excel and Google Sheets. Both programs go through the same procedure since they use many of the same functions and equations.

Regardless of the tool you choose, you may complete the work by following the instructions shown below.

How to Count Cells with Text in Excel?


Here is how to count cells with text in Excel:

  1. Select a cell where you want to display the count
  2. Use the equation =COUNTIF
  3. Select the range of data you want to include in your query
  4. Enter “*” as the criteria to look for any text in the range
  5. Press enter to count the cells with text

Open Microsoft Excel and go to the cell where you want to do the count. Begin by hitting the = symbol and solving the following equation:

=countif(range,criteria)

How to Count Cells with Text in Excel?

In the above example, the range is cells A1 through A8 (A1:A8), and the criteria are “*,” which implies any cell with text. The asterisk is a wildcard symbol that represents “any letters or words.”

The equation properly-recognized five cells containing text, as shown above. The outcome is shown in cell A10.

 

How to Count Cells with Text in Google Sheets?


Here is how to count cells with text in Google Sheets:

  1. Select a cell where you want to display the count
  2. Use the equation =COUNTIF
  3. Select the range of data you want to include in your query
  4. Enter “*” as the criteria to look for any text in the range
  5. Press enter to count the cells with text

Open your data in Google Sheets first. Locate an empty cell where you want to execute the count. Start inputting the equation, which should look like this:

=countif(range,criteria)

How to Count Cells with Text in Google Sheets

In the figure above, we’re looking at column A, which has six items. Cell A7 has the countif equation, which properly finds that there are three cells with text. Because the remaining three cells contain numbers, they are omitted from the count.

spot_img

Subscribe

Related articles

OnePlus 5T Wallpapers Download

Introduction: The OnePlus 5T is a popular smartphone known for...

Airtel’s First Quarterly Loss in 2002: A Closer Look at Jio’s Impact

The telecom industry has witnessed several significant shifts over...

Xiaomi Confirms Investment in Blackshark Gaming Phone Launch set for April 13

An engaging introduction to Xiaomi Confirms Investment in Blackshark...

LG G7 ThinQ M LCD Panel

Introduction:The LG G7 ThinQ M LCD panel is a...

Intel Core i9 Laptops with Optane Memory

Intel Core i9 laptops with Optane Memory combine the...

Apple iOS 11.4 Beta 1

Apple iOS 11.4 Beta 1 is the latest update...

Google Search AI Reorganization: Improving Search Quality and User Experience

Introduction:In the ever-evolving digital landscape, search engines play a...
Peter Graham
Peter Grahamhttp://fix-iphones.com
Hi there! I'm Peter, a software engineer and tech enthusiast with over 10 years of experience in the field. I have a passion for sharing my knowledge and helping others understand the latest developments in the tech world. When I'm not coding, you can find me hiking or trying out the latest gadgets.

LEAVE A REPLY

Please enter your comment!
Please enter your name here