for from 1 to less than 10 ft
=AVERAGEIFS(B2:B10,B2:B10,">="&D2,B2:B10,"<"&E2)