Average Grade

[RussChilds]

Good morning everyone!

I have spread sheet with student grades. The grades range from 1 to 9. Each student is a group. There are 4 groups: Group 1, Group 2, Group 3 & Group 4.

I have a summary sheet. I'm counting up each individual glade for each group. This works fine. Formula here:

=SUM(COUNTIFS(G:G,{"Group 1"},H:H,"2"))

What I want to show for each student is the average grade for their group. Can you help?

Many thanks,
Russell

Group Student Name Grade Average grade for Group
Group 2 Student 1 7 ??
Group 3 Student 2 4 ??
Group 1 Student 3 4 ??
Group 2 Student 4 5 ??
Group 4 Student 5 4 ??
Group 3 Student 6 2 ??
Group 1 Student 7 6 ??

 

[Marcelo Branco]

Assuming data in columns A:C, headers in row 1, try

D2 copied down
=AVERAGEIF(A:A,A2,C:C)

M.