We are in the process of updating the site, so some pages still have the older design.
Count Cells that Contain Specific Text in Excel
Simple formula to count the occurrence of any text value in a cell or range of cells in Excel.
You will learn:
- How to count values that come at the start of a cell.
- How to count values that come at the end of a cell.
- How to count values that are in the middle of a cell.
- How to count values that are located anywhere in a cell.
This simple tutorial combines the COUNTIF() function with wildcard characters.
Count Text Formula
=COUNTIF(A1:A5,"*red*")red is the sample word to look for.
* asterisk is placed before and after the word and it means to match any character. You can place one of these before the text, one after the text, or one asterisk before and after the text.
Additional Resources
CountIf Function in Excel (microsoft resource)
Count Words in Cells in Excel (older resource) (microsoft resource)
Download the Project Files
Follow along with the tutorial by downloading the files used in it. (Completely Free)
Phone number is optional - we use it to send course discounts and weekly updates via SMS.
View our Privacy Policy | Terms of Use
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: How to count the number of cells that contain specific text within a spreadsheet in Excel....
Tutorial: How to count cells that match text at the start or the end of a string in Excel. If you w...
Tutorial: Wildcards are characters that allow you to make more robust functions, searches, and filt...
Tutorial: Find if a cell or range of cells contains a specific value in Excel. This method can be us...
Tutorial: Count the number of cells that contain TRUE, FALSE, or one of the two. This lets you count...
Tutorial: How to remove spaces from the middle of text in Excel. This includes removing all space...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)