Forum Discussion
Lucie666
Jan 19, 2023Copper Contributor
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 cel...
HansVogelaar
Jan 19, 2023MVP
=NB.SI(A1:A100; "*substitution*")