字符求和,怎么弄,请教下

raisons[蛋糕] · 发表于 2024-6-28 16:00

本帖最后由 raisons[蛋糕] 于 2024-6-28 16:17 编辑

我替换成后,怎么求出来A类多少台,因为是*几台那样

hugeinfo · 发表于 2024-6-28 16:02

=COUNTA(UNIQUE(TAKE(TEXTSPLIT(B2,"*",","),,1)))

mountain119 · 发表于 2024-6-28 16:06

复制代码

袁勇 · 发表于 2024-6-28 16:09

=SUMPRODUCT(TEXT(SUBSTITUTE(TRIM(MID(SUBSTITUTE(B2,",",REPT(" ",50)),ROW($1:$10)*50-49,50)),"A类*",""),"0;!0;0;!0")*1)

夜雨无声1949 · 发表于 2024-6-28 16:10

=SUM((IFERROR(--TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"*1",REPT(" ",99)),",",),ROW($1:$99)*99-98,99)),0)=D2)*1)

复制代码

清梦扰 · 发表于 2024-6-28 16:19

=SUM(--REGEXP(B2,"(?<=A类\*)\d+"))

hxj119 · 发表于 2024-6-28 16:21

=LET(x,WRAPROWS(TEXTSPLIT($B$2,{"*",","}),2),SUM((CHOOSECOLS(x,1)=E2)*(CHOOSECOLS(x,2))))

祝洪忠- · 发表于 2024-6-28 16:35

本帖最后由祝洪忠- 于 2024-6-28 16:39 编辑

=SUM(1*TEXT(SUBSTITUTE(TEXTSPLIT(A2,","),"10045*",),"0;;;!0"))

=SUM(IFERROR(TEXTSPLIT(B2,",","A类*")*1,))

		自动登录	找回密码
密码			免费注册

[已解决] 字符求和,怎么弄,请教下