http://img38.imageshack.us/img38/7975/countteam.png

Hi everyone, I tried to count all the football team in sheet number 1, but I have to type in all the team name.

I have like 120 teams name; it is possible to count all the team name without typing all the text?

thank you