Averaging a Range of Cells Using a List

[cosmica67]

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.

[Fluff13]

How about

Please Login or Register  to view this content.

[oeldere]

K2=AVERAGEIF('Year 1'!C$2:C$364,">0")

[cosmica67]

Hi, Fluff13.

Many thanks for suggesting this formula. I've tried it out and it works a treat.

Many thanks for looking at this for me! I appreciate your time.

[Fluff13]

Glad to help & thanks for the feedback.