總和 後面有無字母 (9028)

D2=SUM(RIGHT(SMALL(IFERROR(LEFT(B2:B8,COLUMN(A:I))*1,)+ROW(1:7)*10^9,ROW(1:7)*9),9)*1)

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

另解=SUMPRODUCT(--TEXT(LEFT(TEXT(LEFT(B2:B8&"a",COLUMN(A:I)),),COLUMN(A:I)-1),"0.00;;;!0"))

另解{=SUM(IFERROR(LEFT(TEXT(LEFT(B2:B8&"A",COLUMN(A:I)),),COLUMN(A:I)-1)*1,))

字母只能一位或無{=SUM(IFERROR(F5:F14*1,LEFT(F5:F14,LEN(F5:F14)-1))*1)