How do you calculate a final percentage for grades in a class using excel?

homework for school and i can't figure out the equation in excelHow do you calculate a final percentage for grades in a class using excel?
More information is needed but I'll assume you have names in column A and scores in column B. Then in a different column than A and B put the names and the formula below. For example assume column A has

Mike

Dan

Mike

Dan

and column B has

80

92

90

94



Then below the data (I'll just assume on line 100) put in cell C100

Mike

and in C101 put

Dan

(etc.)

In D100 put

=SUMIF(A:A,C100,B:B)/COUNTIF(A:A,C100)

and copy that down.



What this does is sum the scores for each name in column C, and divides by the count of that name, giving the average score.



Hope that helps, just guessing at what you need based on limited info.

renova

walkie talkie