Please help me win my fantasy football league by answering this excel ?

[NJD]

Thanks in advance for any help. Here is my challenge. I want to
track stats for players on rows. Have a different row for each of the
last three seasons (They are in the same columns so I can data sort
and all of player x's stats for the lest three seasons are in three
rows. How do I get Excel to recognize that the value (a-z) in the
name field matches and THEN average together one cell from each of the
three rows.

e.g. 06 Jo Johnson 48
05 Jo Johnson
57


How do I write one cell that excel will know is asking me to average
all of the number values if the names match?

I am a rookie so if this one is obvious I apologize.

NJD

 

[Mike H]

Hi Nicholas,

If I understand correctly you have a column of names of players (Col B) and
a column of stats (Col C)

This formula looks down Column B and works out the average of all Jo
Johnson's stats. There's no need to sort the players names.

=SUMIF(B1:B100,"=Jo Johnson",C1:C100)/COUNTIF(B1:B100,"Jo Johnson")

Mike