二日期之間 數值去最大與最小 求平均 (14759)

C15{=AVERAGE(SMALL(IF((A1:A12>=A15)*(A1:A12<=B15),C1:C12),ROW(INDIRECT("2:"&COUNTIFS(A1:A12,">="&A15,A1:A12,"<="&B15)-1))))

另解{=TRIMMEAN(IF((A1:A12>=A15)*(A1:A12<=B15),C1:C12),1/2)