Getting an average value from a range, with 3 variables

Hi guys,

Hoping you can help me out.

I have a table which shows values daily of performance, for multiple regions.

My quest is to be able to input two dates (start date and end date), plus the region, and for a formula to be able to calculate the average performance between those two dates for that region.

Excel workbook attached for clarity.

Please help!

Thanks, Cai

Originally Posted by Glenn Kennedy

One way:

=LET(A,B3:B100,B,C3:G100,C,C2:G2,D,FILTER(B,C=K4),AVERAGE(FILTER(D,(A>=K2)*(A<=K3))))

Well THAT worked a treat. Thank you so much for such a quick response and elegant solution.