复制到区域:
第一步:=LOOKUP(X2,{60,63.5,67.5,71.5,74.5,77.5,81.5,84.5,89.5},{1,1.5,2,2.3,2.7,3,3.3,3.7,4})
第二步:=SUMPRODUCT(W2:W15,Y2:Y15)/SUM(W2:W15)
复制到区域:
第一步:=LOOKUP(X2,{60,63.5,67.5,71.5,74.5,77.5,81.5,84.5,89.5},{1,1.5,2,2.3,2.7,3,3.3,3.7,4})
第二步:=SUMPRODUCT(W2:W15,Y2:Y15)/SUM(W2:W15)