看看是不是你要的答案！
=SUMPRODUCT(LOOKUP(B3:H3,{"A","B","C"},{8,9,7}))
=SUMPRODUCT(($A$3:$H$3="A")*8+($A$3:$H$3="B")*9+($A$3:$H$3="C")*7)
