Add and count
Count cells that contain a word
=COUNTIF(A2:A5,"*north*")How it works in Excel
- A2:A5 is the list.
- The * signs mean "anything can be here".
- So it counts any cell with "north" inside it.
- Upper and lower case are treated the same.
- For a word in another cell, use "*"&E2&"*".
The idea in general
It looks for a word anywhere in the text, not just an exact match.
What I assumed
- Your text is in A2:A5.
Check the result on your own data before relying on it.