單格數字總和 (13763)

C2=SUMPRODUCT(TEXT(LEFT(TEXT(MID(B2&"Z",COLUMN(A:Z),ROW($1:$26)),),ROW($1:$26)-1),"0%;;0;!0")*ISERR(-MID(B2,COLUMN(A:Z)-1,2)))

D2{=SUM(RIGHT(SMALL(IFERROR(MID(TEXT(MID("A"&B2,ROW($1:$26),COLUMN(A:Z)),),2,9)*1,)+ROW($1:$26)*10^9,ROW($1:$26)*26),9)*1)