Forum Discussion
Solved
Working out an automatic Average across from 1 of 3 courses (in one coloumn) for each score column
Hi, Hoping you Excel Wizards out there can tell me how one would go about the following please? I want to be able to automatically have the scores give an average for the different types of cour...
=AVERAGEIF($A$2:$A$8,$A12,B$2:B$8)Maybe with this formula for the average of each course and question.
=AVERAGE(IF($A$2:$A$8=A17,$B$2:$H$8))Maybe with this formula for the overall average of each course. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
=AVERAGEIF($A$2:$A$8,$A12,B$2:B$8)Maybe with this formula for the average of each course and question.
=AVERAGE(IF($A$2:$A$8=A17,$B$2:$H$8))Maybe with this formula for the overall average of each course. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
Thanks both, I'll try these in a bit 🙂