How to count Excel cells that Begin or End with specific text ?

What formula should I use to count Excel cells, that begin or end with specific text value ?
02 Aug 2019 at 07:33 PM
0give a positive ratinggive a negative ratingshow more
GillGill
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")

count cells that begin or end with specific text
04 Aug 2019 at 12:31 PM
0give a positive ratinggive a negative ratingshow more
TimTim
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook
2022 AnswerTabsTermsContact us