Forum Discussion
Excel question about adding up multiple words
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.
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