求助单元格内括号内数字的和

肥鱼2022

6221冰泉喷雾 (2),多重智能抗菌除臭袜 (大码）(2),纪念币 (小）(9)

数字内的和为13.怎么把括号内数字的和求出来！求老师救命！

jivy1212

1. =SUMPRODUCT(--TEXT(MID(TEXT(MID(SUBSTITUTE(B2,")",REPT(" ",9)),ROW($1:$66),9),),2,8),"0;;;!0"))

复制代码

红叶黄花

限1位数，数组公式ctrl shift enter
=-SUM(IFERROR(--MID(B2,ROW($5:$99),3),))

一剑惊心

1. =SUM(-TEXT(MID(B2,ROW($1:$50),{1,2,3}),"\0;-0;;\0"))

复制代码

就附件而言

tqlld

=SUM(--TEXT(MID(SUBSTITUTE(B2," ","@")&"@",ROW($1:$99),COLUMN(A:J)),"!0;0.00;0;!0"))

cinlo

=SUM(IFERROR(1*MID(TEXT(MID(SUBSTITUTE(ASC(B2),")",REPT(" ",9)),ROW($1:99),9),),2,9),))

我的城市你来过

=SUM(REGEXP($B2,"(?<=\()[0-9.]+")/1)