长公式=SUMPRODUCT(((Sheet2!$C$2:$C$1206=$A2)*Sheet2!$D$2:$D$1206>=LARGE((Sheet2!$C$2:$C$1206=$A2)*Sheet2!$D$2:$D$1206,40))*(Sheet2!$C$2:$C$1206=$A2)*Sheet2!E$2:E$1206)/SUMPRODUCT(((Sheet2!$C$2:$C$1206=$A2)*Sheet2!$D$2:$D$1206>=LARGE((Sheet2!$C$2:$C$1206=$A2)*Sheet2!$D$2:$D$1206,40))*1)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024