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 ?
posted on 26.07.2019 at 19:32
0pnshow more
GillGill
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 begining or at the end or in the middle.

posted on 03.08.2019 at 19:53
1pnshow more
TimTim
share on facebookshare on twitter
2020 AnswerTabsTermsContact us
This site uses cookies to improve your experience, for analytics and ads. By continuing to browse this site you agree to our use of cookies.