求一个函数公式，谢谢

求值，求函数公式，你的公式关系呢

=sum($B$2:$B$9*countif(B14,"*"&$A$2:$A$9$&"*"))

=sum(sumif(a$2:a$9,textsplit(b14,"/"),b$2))

=SUM(IFERROR(IF(FIND(A2:A9,B12),B2:B9,),0))

=SUM(IFERROR(VLOOKUP(MID(A11,SEQUENCE(,LEN(A11),1,2),1),A1:B6,2,),))

像我这种就比较聪明了，我TM直接加

直接sum（单元格位置），不行吗

=SUM(IF(TEXTSPLIT(B14,"/")=$A$2:$A$9,$B$2:$B$9,0))

=SUM(SUMIFS(B:B,A:A,MID(B12,SEQUENCE(LEN(B12),1,1),1)))

=SUM(SUMIFS(B:B,A:A,TRIM(MID(SUBSTITUTE(B12,"/",REPT(" ",100)),SEQUENCE(LEN(B12)+1-LEN(SUBSTITUTE(B12,"/","")),1,1)*100-99,100))))