What formula should I use to count Excel cells that include the specific part of text value ?

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*")

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.

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*")

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.

Related questions

## How to add side by side rows in excel pivot table ?

## Is CSV excel file Comma or Semicolon separated / delimited ?

## How to change the font of equation formula in Word ?

## Check if value exists in column more than once or twice - Excel

## How to show Euro, Dollar or Pound sign on right in Excel ?

## Set Cookies - specific expiry date and time format

## Move excel chart horizontal axis to bottom - below negative values

Trending questions

Remove or hide bottom navigation bar with buttons on Android How to calculate inverse currency exchange rate ? Best free attractions in London - free things to do in London How to add side by side rows in excel pivot table ? How to change QWERTZ keyboard to QWERTY in Windows 10 ? Man Month calculation - how many man days or man hours ? How to calculate how many Man Days are 3 Man Hours ?

Remove or hide bottom navigation bar with buttons on Android How to calculate inverse currency exchange rate ? Best free attractions in London - free things to do in London How to add side by side rows in excel pivot table ? How to change QWERTZ keyboard to QWERTY in Windows 10 ? Man Month calculation - how many man days or man hours ? How to calculate how many Man Days are 3 Man Hours ?

Follow us on Facebook

2022 AnswerTabsTermsContact us