I am trying to add multiple words on Excel and cannot find the correct formula. For example, I want to know how many times the words Dave, John and James appear in a cell range.
You better use a Pivot Table with the column of these word is dragged into both the rows and values boxes.
The formula you need uses the COUNTIFS formula.
With the following syntax:
This will count how many times Dave appears in column D
You can find more information about COUNTIFS function in the following link: