sourabhg98: I've tried using your first formula, i.e. "=AVERAGE(INDIRECT("B"&MATCH(F2,A:A,0)&":"&"B"&MATCH(F3,A:A,0)))"
However, the number I get for the B row is slightly off (56.84615 instead of 55.91667) and the same goes for the C row.
I have uploaded my Excel-file.
Thank you guys so much for your attempts so far!
Bookmarks