In my worksheet I have a lot of cells filled with different data, but some of them have similar values in it. How can I count the cells with particular text?
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.)
How to count cells with certain text in Excel
0
Answers
0
Selected Answer
Jayden
If you had data in cells A1:A6 say and were looking for "word", you use COUNTIF and put the * wildcard either side of that criteria, so
=COUNTIF(A1:A6,"*word*")In my example above, it would count also a cell containing "foreword" too, but you could put a space after the first wildcard like this:
=COUNTIF(A1:A6,"* word*")To get only cells ending in " word",use:
=COUNTIF(A1:A6,"* word")Hope you can use this.
Discussion
Hi John,
I don't understand how when looking for "word" it would count "forward". Maybe change your example to use "buzzword" instead of "forward"
I don't understand how when looking for "word" it would count "forward". Maybe change your example to use "buzzword" instead of "forward"
WillieD24 (rep: 547) Sep 25, '21 at 12:52 pm
Thanks Willie, my mistake! I've changed the example to "foreword" instead
John_Ru (rep: 6142) Sep 25, '21 at 12:56 pm