How to count excel cells that contain specific part of text ?

What formula should I use to count Excel cells that include the specific part of text value ?
0
give a positive ratinggive a negative rating
26 Jul 2019 at 07:32 PM
Hi,

To count the number of cells that contain specific part of text, you can use the function COUNTIF and you have to include * into criteria. For example to count the number of cells, that include "London", you have to use the following formula:

=COUNTIF(B2:B9,"*London*")

count cells with specific text excel

This formula will find 4 matching cells. It counts the cells, that contain "London" at the beginning or at the end or in the middle.

1
give a positive ratinggive a negative rating
03 Aug 2019 at 07:53 PM
Tim
Share on FacebookShare on TwitterShare on LinkedInSend email
x
x
Find us on Facebook
2023 AnswerTabsTermsContact us
How would you rate your experience with AnswerTabs ?
Very badVery good
Feedback
Thank you for your feedback.
Close