Average of Cells with referance to name in column.

  • Thread starter Thread starter the-jackal
  • Start date Start date
T

the-jackal

Hi,
Not sure if the name of this thread makes any sense but here ya go.

I am creating a score card for a weekly Darts match. I have a
spreadsheet that works out the average per dart and per throw but would
like to also work out the average per throw for the whole night for each
person.

Each team member may get up to 4 games so if there name is in column A
can I pick up all there Average scores from that row and work out the
Average for each player in a separate cell?

Thanks in advance

Carl
 
Assuming the scores are in column B:

=sumif(A:A,player name,B:B)/countif(A:A,player name)
 
I cant for the life of me get this to work. I even created a simpl
spreadsheet with 2 columns and it keeps giving me a Divide by 0 error.

I obviously changed the "player name" to the name I required.

I have the Players names listed in B and the scores are in U so
changed the formula to those columns. I am now thinking of putting th
averages on a separate sheet so the names will be in A on sheet1 an
their Average should be in B

How would I get this to work?

Thanks again

Carl
Assuming the scores are in column B:

=sumif(A:A,player name,B:B)/countif(A:A,player name)

[/i][/color
Click to expand...
Click to expand...
 
Back
Top