请教老师，用公式把每个数的前数相加，就是十位数相加，谢谢！

cartel

请教老师，用公式把每个数的前数相加，就是十位数相加，谢谢！.rar (9.7 KB, 下载次数: 27)

2024-11-15 18:14 上传

点击文件名下载附件

良良

=SUM(--LEFT(TEXT(TEXTSPLIT(E1,","),0&0)))

Excel_muke

1. =SUM(VALUE(LEFT(TEXT(TEXTSPLIT(E1,","),"00"),1)))

复制代码

cjc209

=SUM(--REGEXP(E1,"\d(?=\d)"))

你是那块小饼干

1. =SUM(LEFT(TEXT(TEXTSPLIT(E1,,",",TRUE),"00"),1)*1)

复制代码

mykitami

=SUM(INT(TEXTSPLIT(E1,,",",1)/10))

leepoison

=MAP(E1:E4,LAMBDA(x,SUM(INT(REGEXP(x,"\d+")/10))))

Excel地板砖

1. =SUM(--LEFT(TEXT(TRIM(MID(SUBSTITUTE(E1,",",REPT(" ",100)),ROW($1:$6)*100-99,100)),"00")))

复制代码

忙到飞起

=MAP(E1:E4,LAMBDA(x,SUM(LEFT(TEXT(TEXTSPLIT(x,","),"00"))*1)))

wb1983

=SUM(IFERROR(INT(RIGHT(--MID(SUBSTITUTE(E1,",",REPT(" ",100)),1+(ROW($1:$10)-1)*100,20),2)/10),0))

双花括号

如果有三位数以上，这个公式也是适用的。

数组里，已经包含10个数，如果超过的话ROW($1:$10)，把这里的10改成增加的数