Excel question about adding up multiple words

Highlighted
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
Highlighted

You better use a Pivot Table with the column of these word is dragged into both the rows and values boxes.

OR

The formula you need uses the COUNTIFS formula.

With the following syntax:

=Countifs(D:D,"Dave")

This will count how many times Dave appears in column D

You can find more information about COUNTIFS function in the following link:

https://support.office.com/en-us/article/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842