2019及以上版本
=SUM(--(0&TRIM(MID(SUBSTITUTE(TRIM(CONCAT(SUBSTITUTE(MIDB(A2,ROW(1:99),1),"+","")))," ",REPT(" ",99)),ROW($1:$9)*99-98,99))))
365版本
=SUM(--TEXTSPLIT(A2,TEXTSPLIT(A2,SEQUENCE(10,,0),,1),,1))
2003及以上版本
=SUM(MOD(SMALL(--TEXT(MID(TEXT(MID(A2,ROW($1:$99),COLUMN(A:D)),),2,4),"0;;0;!0")+ROW(1:99)/1%%,ROW(1:99)*4),10^4))