按照要求提取金额

非得正则吗

=MAP($F$2:$J$2,LAMBDA(x,SUM((ISNUMBER(FIND(x,$B$2:$B$16))*($A$2:$A$16=E3)*($C$2:$C$16)))))

=SUMIFS(C:C,A:A,E3,B:B,"*"&F$2:J$2&"*")

=PIVOTBY(A2:A16,TOCOL(REGEXP(B2:B16,G1:K1),3,0),C2:C16,SUM,,0,,0)

表头顺序无要求的话
=PIVOTBY(A2:A16,REGEXP(B2:B16,TEXTJOIN("|",,F2:J2)),C2:C16,SUM,,0,,0)

=PIVOTBY(A2:A16,SUBSTITUTES(B2:B16,{"基本","支出","奖金","保险","住房"},),C2:C16,SUM,,0,,0)

您好，原数据16，我要收集数据的这些数字里面有116和16这样的数字，它把里面的数据提取了两次怎么办啊楼主，现在116的也调用了16里面的数据。

=groupby(a2:A16,Isnumber(find(E2:J2,b2:b16))*c2:C16,sum,0,0,)