Excel - how to count the number of cells that have a specific word in a column

Hello!

I'm trying to count the occurrence a term appears in a column. I tried with the =NB.SI.ENS formula but it seems only counting the cells countaining the only word (it doesn't work with the cells having the word among others).

Example: in the cells, I may have written two words: an action (substitution / ajout / suppression / déplacement) and a category (lexique / temps / expression, etc.). Therefore, a cell may contain "substitution lexique", and I would like to count those having "substitution" whatever words come after.

Does anyone would know how to help me?

Thank you very very much in advance!!