加總 名字後面數字 (14131)

C6{=SUM(RIGHT(SMALL(IFERROR(RIGHT(C2:C5,COLUMN(A:I))*1,)+ROW(1:4)*10^9,ROW(1:4)*9),9)*1)

D2:D5=-LOOKUP(1,-RIGHT(C2,ROW($1:$9)))

C7=SUM(D:D)