求助excel A=90 B=80 C=70 D=60 如何算平均分 求助~~~亲答:=SUM((LOOKUP(B3:O3,{"A",90;"B",80;"C",70;"D",60}))/14)或 =AVERAGE(LOOKUP(B3:O3,{"A",90;"B",80;"C",70;"D",60}))或者自动判断有多少数据 =SUM(IF(B3:S3="",,LOOKUP(B3:S3,{"A",90;"B",80;"C",70;"D",60})))/COUNTA(B3:S3)或者 =SUM(IF(B3:S3="...