如何统计数据和选取数据

更更

=SUM(VALUE(MID(B3:F3,3,LEN(B3:F3)-3)))

尔双甬力量

H3=SUMPRODUCT(--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B3:F3,"S/",""),"p",""),"a",""))，Feb表，G3=Jan!I3

蜡笔小非

=SUM(VALUE(MID($B$3:$F$3,3,LEN($B$3:$F$3)-3)))，再按ctrl+shift+enter

木易楊

谢谢帮助~~~

南小刀

谢谢帮助~~~~

汉王刘启

谢谢帮助~~~

仕宾

谢谢帮助~~~

雁心

谢谢帮助~~~

吕凤千

H3=SUMPRODUCT(--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B3:F3,"S/",""),"p",""),"a",""))，Feb表，G3=Jan!I3

江小杨

=SUM(VALUE(MID($B$3:$F$3,3,LEN($B$3:$F$3)-3)))，再按ctrl+shift+enter