二對應數值取出後加總 (13084)

G2:J5=IFERROR(VLOOKUP(G$1,$B$14:$C$17,2,)+TEXT(SUMIFS($C$2:$C$9,$B$2:$B$9,"*"&VLOOKUP(G$1,IF({1,0},$B$14:$B$17,$A$14:$A$17),2,)&"*",$A$2:$A$9,$F2),"0;;"),"")