每行以A开头数字的和 (11009)

F2{=SUM(RIGHT(LARGE(IFERROR(RIGHT(A2:E2,ROW($1:$9))*1,)+COLUMN(A:E)*10^5,(6-COLUMN(A:E))*9-8),5)*(LEFT(A2:E2)="A"))

另解{=SUM(RIGHT(SMALL(IFERROR(MID(A2:E2,ROW($1:$9),9)*(LEFT(A2:E2)="A"),)+COLUMN(A:E)*10^5,COLUMN(A:E)*9),5)*1)