字母对应分值列表吗？如果有可引用，如果没有就用下面这个公式。=SUMPRODUCT(COUNTIF(A1,"*"&{"Y","D","T","R","A","P"}&"*")*{10,8,10,0,6,8})
