这样试试=SUMPRODUCT(LOOKUP(A1:L1,{0,"A","C","S";0,5,6,2}))
=SUMPRODUCT((C1:L1="A")*5+(C1:L1="C")*2+(C1:L1="S")*6)
