What formula should I use to count Excel cells, that begin or end with specific text value ?

Hi,

To count the number of cells, that begin or end with specific text, you can use the function COUNTIF. You have to add * into the forumla's criteria. It has to be placed according to your needs, before or after a specific text, that you are looking for.

The following formula will count the cells, that begin with "London":

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

And this formula will count the cells, that end with "London":

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

To count the number of cells, that begin or end with specific text, you can use the function COUNTIF. You have to add * into the forumla's criteria. It has to be placed according to your needs, before or after a specific text, that you are looking for.

The following formula will count the cells, that begin with "London":

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

And this formula will count the cells, that end with "London":

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

Related questions

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

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

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

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

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

## Invalid cell reference error in Excel vLookup function - #REF!

## How to calculate percentage changes / growth in Excel ?

Trending questions

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

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

Follow us on Facebook

2022 AnswerTabsTermsContact us