求助用函数求和数字

Justin-2016 · 发表于 2023-6-28 08:08

本帖最后由 Justin-2016 于 2023-6-28 08:31 编辑

zhaojiaoyang200 · 发表于 2023-6-28 08:22

=SUBSTITUTE(SUBSTITUTE(IMSUM(SUBSTITUTE(SUBSTITUTE(0&C4:K4,"（","+"),"）","i")),"+","（"),"i","）")

hugeinfo · 发表于 2023-6-28 08:25

=SUM(--IFERROR(LEFT(C4:L4, FIND("（",C4:L4)-1),0))&"（"&SUM(--IFERROR(MID(C4:L4,FIND("（",C4:L4)+1,FIND("）",C4:L4)-FIND("（",C4:L4)-1),0))&"）"

橒♂蝣 · 发表于 2023-6-28 08:26

=LET(x,FILTER(C4:L4,ISTEXT(C4:L4)),
SUM(--LEFT(x,1))&"("&SUM(--MID(x,3,1))&")"
)

袁勇 · 发表于 2023-6-28 08:27

=SUBSTITUTE(SUBSTITUTE(IMSUM(SUBSTITUTE(SUBSTITUTE(T(OFFSET(C4,,{0,4,8})),"（","+"),"）","i")),"+","（"),"i","）")

袁勇 · 发表于 2023-6-28 08:27

=SUBSTITUTE(SUBSTITUTE(IMSUM(SUBSTITUTE(SUBSTITUTE(T(OFFSET(C4,,{0,4,8})),"（","+"),"）","i")),"+","（"),"i","）")

机智 · 发表于 2023-6-28 08:48

=SUMPRODUCT(IFERROR(--LEFT($C$4:$K$4),0))&"("&SUMPRODUCT(IFERROR(--MID($C$4:$K$4,3,1),0))&")"

quqiyuan · 发表于 2023-6-28 09:46

=TEXTJOIN("(",,MMULT({1,1,1},--TEXTSPLIT(TEXTJOIN("；",1,SUBSTITUTE(C4:L4,"）","")),"（","；")))&")"

hcm19522 · 发表于 2023-6-28 12:05

以時間算分 > 59 有誤{=TEXT(SUM(IFERROR(SUBSTITUTE(LEFT(C4:L4,LEN(C4:L4)-1),"（",":")*1,)),"[H]!（M")&"）"

renzidong · 发表于 2023-6-28 15:57

=SUM(IFNA(TEXTBEFORE(C4:L4,"（")*1,0))&"（"&SUM(IFNA(TEXTBEFORE(TEXTAFTER(C4:L4,"（"),"）")*1,0))&"）"

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

[已解决] 求助用函数求和数字