## 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 ? | |||||||||||

| |||||||||||

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

| |||||||||||

2019 AnswerTabs | Terms | Contact 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.✕