=SUM(IF(ISERROR(SEARCH("+",A1:C1)),A1:C1,LEFT(A1:C1,SEARCH("+",A1:C1)-1)+MID(A1:C1,SEARCH("+",A1:C1)+1,LEN(A1:C1)-SEARCH("+",A1:C1))))输完公式后，按ctrl+shift+enter将之变为数组公式就可以了
