Average multiple scores of the same topic
up vote 0 down vote favorite 1 Say I have a spreadsheet that contains quizzes taken by students and their scores. I want to create another table of that data the gives me an average of 2 quizzes that are related to the same topic. I have attached an example. Not all topics contain two different quizzes, some just consist of one single quiz. Maybe someone could help me solve this. enter image description here I tried to use a pivot table but it creates a column for each test, not exactly what I need. excel google-sheets excel-formula share | improve this question asked Nov 10 at 16:10 Firefox17 10 3 So have you tried AVERAGEIFS() ? – Solar Mike Nov 10 at 16:17 @SolarMike I couldn't find an example of a similar use of AVERAGEIFS() – Firefox17 Nov 10 at 17:02 Well, the answer shown does a good job, it’s also in the excel help. – Solar Mike Nov 10 at 17:16 add a comment...