EXCEL怎么取单元格中字符后的数字相加?答:=SUM(--IFERROR(MID(A1,FIND("/",SUBSTITUTE(A1,"=","/",ROW($1:$10)))+1,FIND("-",SUBSTITUTE(A1," ","-",ROW($1:$10)))-FIND("/",SUBSTITUTE(A1,"=","/",ROW($1:$10))),0))+MID(A1,LOOKUP(9^9,FIND("/",SUBSTITUTE(A1,"=","/",ROW($1:$10)))+1,99)...
excel表格中有文字和数字一起,怎样求和?答:B1,ROW($1:$20),1)*1),ROW($1:$20)),1)+1)+RIGHT(C1,LEN(C1)-SMALL(IF(ISNUMBER(MID(C1,ROW($1:$20),1)*1),ROW($1:$20)),1)+1)+RIGHT(D1,LEN(D1)-SMALL(IF(ISNUMBER(MID(D1,ROW($1:$20),1)*1),ROW($1:$20)),1)+1)CTRL+SHIFT+ENTER结束(数组公式)...