Forum Discussion
Average set of values if 2 criteria are met
jtorrens A possible solution is demonstrated in the attached workbook. It dynamically determines the first and last column in your score listing. All you need to do is expand your summary as more courses are added. I've used a helper column in D to achieve this. Hide the column by pressing the group button at the top (and vice versa). Note that the blue shaded cells should remain empty to guarantee correct calculations.
jtorrens A possible solution is demonstrated in the attached workbook. It dynamically determines the first and last column in your score listing. All you need to do is expand your summary as more courses are added. I've used a helper column in D to achieve this. Hide the column by pressing the group button at the top (and vice versa). Note that the blue shaded cells should remain empty to guarantee correct calculations.
Riny_van_Eekelen Thank you so much Riny!!
I finally finished playing around with it and your solution was exactly what I was looking for!!
