How to Count Cells With Text in Excel?

How to Count Cells With Text in Excel?

You can use functions in MS Excel to count general to specific texts. Excel is one of the best ways to store your data for future reference. Having that said, Excel has made data retrieval easier than ever. You can count numbers, texts, blank spaces, and string values using different functions in MS Excel.

This article will look into the different formulas you can use to count text in Excel. Keep reading this article to save time counting cell items in Excel the next time you use it!

How to Count Cells With Text in Excel?

Excel has functions to assist you in counting cell items. Although there are other functions such as COUNT, COUNTA, COUNTIFS, and COUNTBLANK, you need to use the COUNTIF function to count cells with text in Excel. 

Furthermore, if you think using functions is not your cup of tea, you can always use the Find tool to look for the number of times a text has been repeated on the spreadsheet. In this article, we will be looking at both the ways you can look for text and how you can customize your counter using formulas. 

Find Tool

The find tool is the quickest way to find specific items in the cell. Along with locating the value, Excel also provides you with the number of cells in which the value exists. You can use this tool if you’re looking for a fast and convenient way of counting specific values. 

Here are the steps you can follow to use the Find tool in MS Excel:

  1. Open your Excel workbook. 
  2. Hit the combination Ctrl + F to open the Find window.
  3. Next, on the find what search bar, type the item you want to count in the worksheet.
  4. Click on Find All.
    How to Count Cells With Text in Excel?

Excel will display all the cells that contain the value. On the bottom right corner of the window, you can see the number of cells with the data item you entered.

COUNTIF Function

The COUNTIF function is a conditional function that only counts data when it meets specified criteria. You will have to set a range to count data from and criteria that the item must meet for Excel to count it. 

You can customize the COUNTIF function to count particular data using different formulas. To count a set value, you might have to use the wildcards, the Asterisk (*), and the Question mark (?) symbols in the formula. 

The placement of the Asterisk symbol determines what value to count in the cell: 

  • If you place the Asterisk symbol at the end, Excel will count the values starting with your criteria.
  • If you place the symbol in the beginning, Excel will take values ending with the criteria into account. 
  • If you want Excel to count the value with the criteria mentioned anywhere, you need to open and close the criteria with the Asterisk symbol. You can also use only the Asterisk symbol to count all cells that include only text.

The Question mark symbol fills in the missing characters in your criteria. This is handy if you’re looking to count multiple data with a few different characters. For instance, p?m will count both pam and pom. 

You can furthermore combine Asterisks and Question mark symbols in your criteria. If you only use the combination of Asterisk and Question mark, Excel will exclude cells that contain only space while counting cells with text.

Now, let’s move on to how to use the COUNTIF functions to count criteria in MS Excel.

Count All Cells with Text

You can count all cells with text (including space) using the COUNTIF function. For this, you will need to use the mentioned wildcard, Asterisk. 

In an empty cell, enter the following formula:

=COUNTIF(range, “*”)

How to Count Cells With Text in Excel?

Count Cells with Text Excluding Space

When you use the formula to count all cells with text, Excel also counts empty cells that have space in it. You need to use the Asterisk and Question mark symbol in the COUNTIF formula to count cells with text excluding space.

Enter the formula in this format in an empty cell:

=COUNTIF(range, “*?”)

How to Count Cells With Text in Excel?

Count Cells with Specific Data

If you want Excel to count cells with specific data, you can pass only that value as a criterion in the COUNTIF formula. 

Use this format in an empty cell in your worksheet:

=COUNTIF(range, “criteria”)

How to Count Cells With Text in Excel?

Count Cells Starting with Criteria

You can prompt Excel to record the number of values that begin with the criteria passed. For this, you need to end the criteria with the Asterisk symbol. 

Here is the format you can enter in an empty cell:

=COUNTIF(range, “criteria*”)

How to Count Cells With Text in Excel?

Count Cells Ending with Criteria

If you want Excel to count data that only end with the criteria, you need to place the Asterisk symbol at the beginning of your criteria in the COUNTIF formula.

Use this formula format in an empty cell:

=COUNTIF(range, “*criteria”)

How to Count Cells With Text in Excel?

Count Cells with Criteria

Open and close your criteria with the Asterisk symbol in the COUNTIF formula to prompt Excel to count cells with your criteria. Excel will count cells containing the criteria either in the data’s beginning, end or middle.

In an empty cell, enter the formula in this format:

=COUNTIF(range, “*criteria*”)

How to Count Cells With Text in Excel?

Count Similar Cells

If you want to use count cells that are similar but contain a few different characters, you can use the wildcard, the Question mark symbol. Simply replace the distinct characters with ? from the criteria in the COUNTIF formula. 

Enter the formula in this format in an empty cell:

=COUNTIF(range, “cr??eria”)

How to Count Cells With Text in Excel?

News Related

OTHER NEWS

Instructions on how to turn off the Windows 10 standby screen simply

In the article below, GhienCongList will show you how to turn off the Windows 10 standby screen in just 3 easy steps. With users already exposed to the Screen Saver ... Read more »

Genshin Impact: Wandering Evenstar – how to get it, stats, and ascension materials

Image via HoYoverse The Wandering Evenstar is a new 4-star Catalyst weapon in Genshin Impact added in Version 3.1, empowering characters by increasing their Elemental Mastery. Additionally, this weapon provides ... Read more »

The 2023 Porsche 911 GT3 RS Is in Another League

2023 Porsche 911 GT3 RS First drive After a half-century of 911 RS models, Porsche could be suffocated by success, bumping the ceiling of what a gasoline-powered sports car could ... Read more »

Destiny 2 Anti-Cheat Software Unfairly Banned Players, A Fix And Ban Reversals Are On The Way

Human error related to the new anti-cheat caused the bans. Read more »

Cyberpunk 2077 Sequel Announced, Witcher Projects Explained | GameSpot News

CD Projekt Red announces Cyberpunk 2077 sequel as well as several Witcher Games, the Dead Space remake gets its first look at gameplay, and Nintendo announces a Direct around the upcoming Super Smash Bros. movie. Read more »

Genshin Impact: Makhaira Aquamarine – how to get it, stats, and ascension materials

Image via miHoYo The Makhaira Aquamarine is a new 4-star weapon in Genshin Impact added in Version 3.1, empowering characters by increasing their Elemental Mastery. This new weapon will be ... Read more »

New Renault Megane E-Tech 2022 review

The Renault Megane returns as an all-electric SUV, and is all the better for it Read more »

Review NeverAwake

Constructing an intriguing concept is one thing. But to also have the wherewithal to execute it is an entirely different set of expertise. NeverAwake is a title that successfully manages ... Read more »

2023 Porsche 911 GT3 RS First Drive Review: Trick Tech for Track Attack

Motorsport-derived aerodynamics and new adjustability tech make the GT3 RS the ultimate Porsche 911. Read more »

How to unlock heroes as a new player in Overwatch 2

Image via Blizzard Entertainment When you jump into Overwatch 2 as a new player, you will be put through the FTUE, or First Time User Experience. When doing this, you ... Read more »

24 Overwatch Heroes That Never Made The Cut

Heroes in Overwatch are some of the most meticulously designed and well crafted characters in the business. I want to explore some of the characters that either evolved into the heroes we know today, or got left on the cutting room floor. Read more »

How to turn off the Windows 7 standby screen in a few easy steps

Are you looking for a way to turn off the Windows 7 standby screen because it causes more trouble than utility? Discover now GhienCongList’s article below about this issue. Are ... Read more »

How to complete all Evolving Stars Collection Challenges in Pokémon Go

Image via Niantic The Evolving Stars event in Pokémon Go has arrived. The event is a celebration of the next step in the Cosmic Companion Special Research quest and an ... Read more »

How to fix BC-153 login error in Overwatch 2

Image via Blizzard Entertainment Overwatch 2 is here and ready for action after a long wait. Its launch has seen countless players trying to get into the multiplayer, but there ... Read more »

How to play Pharah in Overwatch 2 – Hero Guide

Image via Blizzard Pharah is the queen of the skies in Overwatch, armed with a rocket launcher and a desire for honor. She makes use of vertical space in maps, ... Read more »

CD Projekt Red confirms Cyberpunk 2077 sequel and five more Witcher games

In brief: CD Projekt Red (RED 2.0) confirmed that a Cyberpunk 2077 is definitely on the table. However, it might be a little while as it looks like the priority ... Read more »

7 Best Ways to Fix Netflix Error Code: M7053-1803

Do you keep running into error code M7053-1803 while attempting to play TV shows or movies on Netflix? It’s an issue with Chromium-based browsers like Google Chrome, Microsoft Edge, and ... Read more »

How to fix the Time Out Communicating with Battle.net Services error in Overwatch 2

Image via Blizzard Entertainment When attempting to jump into Overwatch 2, there’s always the possibility of problems occurring when you try loading up the game. It is required to be ... Read more »

How To Set Up Chromecast From Android

Chromecast, Google’s new rolling invention, is a media streaming gadget for your big screens. This article is a comprehensive guide that covers all the aspects of setting up Chromecast from ... Read more »

2023 Hyundai Ioniq 6 review: First drive

8.0/10Score Score breakdown 8.0 Safety, value and features 8.5 Comfort and space 8.5 Engine and gearbox 7.0 Ride and handling 9.0 Technology Things we like Addictive electric performance Spacious, light-filled ... Read more »

Porsche 911 GT3 RS review

Overview What is it? The most extreme Porsche 911 ever produced. This new GT3 RS isn’t just inspired by motorsport, it’s a full-blown race car, albeit one with numberplates that’s ... Read more »

New Porsche 911 GT3 RS 2022 review

We hit the road in the sensational new 518bhp Porsche 911 GT3 RS Read more »

Porsche 911 GT3 RS (2022) review: several steps beyond

► New 992-gen Porsche 911 GT3 RS driven► Tested on track at Silverstone GP circuit► Extreme aero, cleverly configurable dampers When CAR magazine first drove the current 992-generation 911 GT3 in prototype form ... Read more »

What's New In Overwatch 2: Battle Pass, Challenges, How To Transfer Skins, And More

Whether you're new to Overwatch or coming over from the original, here's what you need to know when jumping into the much-anticipated sequel. Read more »

EU overwhelmingly supports a mandatory USB Type-C charging interface

The European Parliament overwhelmingly supports the mandatory use of a USB Type-C charging interface. It will be a universal charging port for various consumer electronic devices including iPhone and AirPods. This ... Read more »

Instructions on how to set screen timeout in Windows 10

Looking for a way to change the display time and idle screen? Please refer to the following article of GhienCongList about how to set screen time to wait in Windows ... Read more »

How to fix the error code BC-153 in Overwatch 2

Image via Blizzard Entertainment There will be a handful of problems every so often while playing Overwatch 2. It’s relatively common to have issues logging into the game, or the ... Read more »

2023 Porsche 911 GT3 RS: Track Star

It’s raining tigers and werewolves through the entire session. Britain’s Silverstone Circuit is not for the faint of heart in dry weather, but with standing water between Woodcote and Copse, ... Read more »

Ron Johnson again says January 6 was not an 'armed insurrection,' adds 'protesters did teach us' how to use flag poles as weapons

Wisconsin Republican Sen. Ron Johnson repeated his claim Tuesday that the January 6, 2021, attack on the US Capitol was not an “armed insurrection,” adding however, that protesters “did teach ... Read more »

How To Convert Excel Files To PDF

If your work involves juggling a lot of data and numbers, you probably use Microsoft Excel or Google Spreadsheets. But, do you know it is always a good practice to ... Read more »

How to Fix Something Went Wrong Outlook Error

If you are using Outlook as your email client, you might have encountered situations where something went wrong. You may face an issue where some of your emails stopped coming, ... Read more »

Loretta Lynn Died at Her Beloved Tennessee Ranch: All About Her Famous Home and How to Visit

Erika Goldring/Getty; Jim Smeal/BEI/Shutterstock Country music legend Loretta Lynn died Tuesday morning at her home in Tennessee. The property, simply dubbed Loretta Lynn’s Ranch, is located in Hurricane Mills, Tennessee. ... Read more »

How to Fix Battery Drain Issues in Windows

One persistent issue that some Windows users seem to be having is battery drain. If you’re also experiencing this, don’t worry – help is here. This post will show you ... Read more »

Blizzard President Explains Why No One Can Play Overwatch 2 Right Now

Today should be a massive day for Overwatch fans as Overwatch 2 has finally released its free-to-play PvP half for everyone. However, no one can currently actually get the game ... Read more »

We’re Now in the Age of 200MP Smartphone Cameras

Xiaomi 108MP smartphones began popping up in 2019, but if you think that resolution was monstrous, think again. 200MP smartphones are here, and they’re becoming more common on the best ... Read more »

How to convert Valorant sensitivity to Overwatch 2

Overwatch 2 is the latest iteration/edition in the long-running Overwatch series. Being a tactical, ability-based shooter game like Valorant, several existing Valorant players are trying their hands at Overwatch 2. ... Read more »

How to make Vanilla Ice Cream in Disney Dreamlight Valley

Screenshot by Pro Game Guides In Disney Dreamlight Valley, players get to make several recipes with all the unique ingredients found in the different biomes. Some of these recipes require ... Read more »

How to make Arendellian Pickled Herring in Dreamlight Valley

Screenshot via Gameloft Making Arendellian Pickled Herring takes resources, patience, and a low sense of smell, but it’s worth it for your friendship with Elsa. Here’s how you can make ... Read more »

How to play Apex Legends Shadow Royale LTM

Screenshot via Respawn Entertainment Apex Legends Shadow Royale is a limited-time mode usually released around Halloween time in the Fight or Fright event. Shadow royale is similar to the normal ... Read more »

How to make Lobster Roll in Disney Dreamlight Valley

Screenshot by Pro Game Guides The Lobster Roll is one of the delicious five-star meals in Disney Dreamlight Valley. To make a Lobster Roll, you must unlock a few areas ... Read more »
Breaking thailand news, thai news, thailand news Verified News Story Network