Excel question about adding up multiple words

Occasional Visitor

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.

1 Reply

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: