Hi, All.
I have attached a spreadsheet that has a formula which needs tweaking to show an average of a range of cells.
In the Data Collation tab, the cell G13 needs to show the average of a range of cells in according to the academic year and the Year.
So, for example in the Data Collation tab:
Cell G13 should look at the Year 1 tab, column B and average all the scores for 2016-2017 in column C which is SS Score 1.
Cell G14 should do the same but for column D which is the SS Score 2.
I am hoping someone can suggest a formula that will replace the existing formula in G13 and G14 to return the average for the data set.
Many thanks for looking.
Bookmarks