Counting

  • Thread starter Thread starter são paulo
  • Start date Start date
S

são paulo

Hello
Can someone help me? I want to make an excel table for a tournament i'
organizing. the function which i'd like to know is the following:
in each column, i'd have the names of the players that have score
goals (each column would be one match). So I'd like to know a formul
that would count how many times each player appears and give me a lis
of all of them.
Was I clear? If not, please ask and I'll try to explain again.
Thanks in advanc
 
How about this
in B1 enter the name you want to count
enter this function in C1 or wherever this is just an example of how t
count

=COUNTIF(A1:A9,B1)
A1:A9 is the range of names
B1 is the criteri
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top