按各區比例计算平均 (13210)

I5=SUMPRODUCT((LOOKUP(1,0/(H5-LEFT(B$1:F$1,2)>=0),(H5-LEFT(B$1:F$1,2))/(RIGHT(B$1:F$1,2)-LEFT(B$1:F$1,2)))*(RIGHT(B$1:F$1,2)-LEFT(B$1:F$1,2))+LEFT(B$1:F$1,2))*B$2:F$2)/SUM(B$2:F$2)