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 ?
posted on 02.08.2019 at 19:33
0pnshow 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
posted on 04.08.2019 at 12:31
0pnshow more
TimTim
share on facebookshare on twitter
2019 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.