多年以后天天弄这玩意
=IF(ISERR(SUMPRODUCT((V10:V77<>0)*ISNUMBER(IF(LEN(A10:A77)=0,"a",VALUE(A10:A77)))*S10:S77)/SUMPRODUCT((S10:S77<>0)*ISNUMBER(IF(LEN(A10:A77)=0,"a",VALUE(A10:A77)))*V10:V77)/7.1/6.3),0,(SUMPRODUCT((V10:V77<>0)*ISNUMBER(IF(LEN(A10:A77)=0,"a",VALUE(A10:A77)))*S10:S77)/SUMPRODUCT((S10:S77<>0)*ISNUMBER(IF(LEN(A10:A77)=0,"a",VALUE(A10:A77)))*V10:V77)/7.1/6.3))