A user ask, I have a list of names in a range of cells. I want to know how many times each of these names are in the list without doing it manually.
Here is a solution, we can use the function countif
On cell C2 type equal, countif, open a parenthesis, then select the range that contain the values you want to evaluate, B10:D17, press F4 to make the reference absolute, comma, then you can define the criteria in two ways, type the name in quotations marks, “A”, or select a cell that contain the name you are looking for, close the parenthesis and press enter,
Copy the formula to the other two cells. And there we have.