综合绩效评价等级 加权後 (11173)

E3=SUMPRODUCT(VLOOKUP(T(IF({1},B3:D3)),B$9:C$13,2,)*B$2:D$2)

F3 {=INDEX(H:H,MATCH(1=1,E3>={95;85;70;60;0},)+1)

另解 E3=SUMPRODUCT(SUMIF(B$9:B$13,B3:D3,C$9:C$13),B$2:D$2)

另解 F3=OFFSET(H$7,-MATCH(E3-1%%,{0,60,70,85,95}),)