總和 前面數字 (11022)

D2{=SUM(RIGHT(SMALL(IFERROR(MID(B2:B5,1,COLUMN(A:I))*1,)+ROW(1:4)*10^9,ROW(1:4)*9),9)*1)

另解=SUMPRODUCT(LEFT(B2:B5,MMULT(1-ISERR(-MID(B2:B5,COLUMN(A:I),1)),ROW(1:9)^0))*1)