How to find the number of cells in Excel that contain a certain value?

Y

YeaNot2021-07-18 16:51:08

excel

YeaNot, 2021-07-18 16:51:08

There is a column where in each cell there are several words separated by commas. How can I get the number of cells that contain a certain word?

For example:
A1: Melon, watermelon, pineapple
A2: Cucumber, tomato, watermelon
A3: Cherry, cucumber, pineapple

2 of them contain the word "watermelon". But you need to get it through the formula.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)