I have a spread shett which is recording lesson observation data e.g.

Subject Grade
Art 3
Maths 1
Art 4
Maths 2
Art 2

I want to get the spreadsheet to avaerage the grades for each subject
seprately e.g. Art 2
Maths 1.5
Does anyone have any ideas what formula(s) I should use.

Many thanks

Nick Horn