|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 我的城市你来过 于 2023-4-6 14:02 编辑
=SUM(IFERROR($B$3:$E$11*1,0))
=SUM(IFERROR(TRIM(MID(SUBSTITUTE(TRIM(SUBSTITUTE(CONCAT(IFERROR(1*MID(TEXTJOIN("@",,IF((ISTEXT($B$3:$E$11)*((LENB($B$3:$E$11)=LEN($B$3:$E$11)))),$B$3:$E$11,"")),ROW(A1:A199),1),"@")),"@"," "))," ",REPT(" ",199)),ROW(A1:A199)*199-198,199))*1,0))
=H9-H5
=SUM(IFERROR(TRIM(MID(SUBSTITUTE(TRIM(SUBSTITUTE(CONCAT(IFERROR(1*MID(TEXTJOIN("@",,IF((ISTEXT($B$3:$E$11)*((LENB($B$3:$E$11)>=LEN($B$3:$E$11)))),$B$3:$E$11,"")),ROW(A1:A199),1),"@")),"@"," "))," ",REPT(" ",199)),ROW(A1:A199)*199-198,199))*1,0))
|
|