Forum Discussion
Roomey
Jun 22, 2020Copper Contributor
Counting number of each entry
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
- SergeiBaklanDiamond Contributor
You may use COUNTIF() as
=COUNTIF(Range,"Team name")where the Range is the reference on your data