更更
发表于 2022-2-27 20:02:16
=SUM(VALUE(MID(B3:F3,3,LEN(B3:F3)-3)))
尔双甬力量
发表于 2022-2-28 09:07:55
H3=SUMPRODUCT(--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B3:F3,"S/",""),"p",""),"a",""))，Feb表，G3=Jan!I3
蜡笔小非
发表于 2022-3-2 06:14:10
=SUM(VALUE(MID($B$3:$F$3,3,LEN($B$3:$F$3)-3)))，再按ctrl+shift+enter
木易楊
发表于 2022-3-6 21:36:07
谢谢帮助~~~
南小刀
发表于 2022-3-12 11:25:08
谢谢帮助~~~~
汉王刘启
发表于 2022-3-13 13:43:43
谢谢帮助~~~
仕宾
发表于 2022-3-13 16:56:04
谢谢帮助~~~
雁心
发表于 2022-3-14 17:14:52
谢谢帮助~~~
吕凤千
发表于 2022-3-17 06:16:09
H3=SUMPRODUCT(--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B3:F3,"S/",""),"p",""),"a",""))，Feb表，G3=Jan!I3
江小杨
发表于 2022-3-17 18:05:54
=SUM(VALUE(MID($B$3:$F$3,3,LEN($B$3:$F$3)-3)))，再按ctrl+shift+enter