Hi
Welcome to the forum.
I am not very sure what are your requirements but try if this is what you need.
For column B average use-
=AVERAGE(INDIRECT("B"&MATCH(F2,A:A,0)&":"&"B"&MATCH(F3,A:A,0)))
For column C average use-
=AVERAGE(INDIRECT("C"&MATCH(F2,A:A,0)&":"&"C"&MATCH(F3,A:A,0)))
Also, as you are new to the forum I would like to tell you that we can upload workbooks at this forum which provide better flexibility than attaching images.
Check out the link in my signature below to know how you can attach workbooks at this forum.
Bookmarks