怎样求出B列的金额数

jisijie630 · 发表于 2023-6-26 20:01

懒猫爱哭发表于 2023-6-26 19:30
我试了公式完全有效，大师强强强

简化一下：

=SUM(SUMIF(E:E,IF(LEN(A2)=8,A2,LEFT(A2,6)&TEXT(ROW(INDIRECT(SUBSTITUTE(MID(A2,7,9),"-",":"))),"00")),F:F))

机智 · 发表于 2023-6-26 20:21

奇怪了，为什么我写的公式返回0=SUMIFS($F$1:$F$18,$E$1:$E$18,">="&LEFT(A2,IFERROR(FIND("-",A2)-1,LEN(A2))),$E$1:$E$18,"<="&LEFT(A2,IFERROR(FIND("-",A2)-1,LEN(A2)))&IF(ISERR(FIND("-",A2)),"",MID(A2,FIND("-",A2)+1,99)))

机智 · 发表于 2023-6-26 20:22

jisijie630 发表于 2023-6-26 19:28
=IFERROR(VLOOKUP(A2,E:F,2,),SUM(SUMIF(E:E,LEFT(A2,6)&TEXT(ROW(INDIRECT(SUBSTITUTE(MID(A2,7,9),"-",": ...

厉害啊，老师，我都看不懂

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

[求助] 怎样求出B列的金额数