Counting number of each entry

%3CLINGO-SUB%20id%3D%22lingo-sub-1480468%22%20slang%3D%22en-US%22%3ECounting%20number%20of%20each%20entry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480468%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20excel%20skills%20are%20pretty%20basic%2C%20so%20I%20apologise%20in%20advance%20if%20my%20terminology%20is%20a%20bit%20off...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20simple%20way%20to%20count%20how%20many%20times%20each%20team%20name%20occurs%20in%20the%20attached%20spreadsheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20how%20many%20times%20Bayern%20Munich%20is%20in%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20Steve%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1480468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, 

 

My excel skills are pretty basic, so I apologise in advance if my terminology is a bit off...

 

Is there a simple way to count how many times each team name occurs in the attached spreadsheet?

 

For example, how many times Bayern Munich is in there.

 

Thanks, Steve

1 Reply
Highlighted

@Roomey 

You may use COUNTIF() as

=COUNTIF(Range,"Team name")

where the Range is the reference on your data