How to count excel cells that contain specific part of text ? | |||||||||||
| 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. | |||||||||||
| |||||||||||
|
| |||||||||||
    | |||||||||||
| 2021 AnswerTabs | Terms | Contact us |
