E2{=SUM(RIGHT(SMALL(IFERROR(MID(D2,SMALL(IF(MID(D2,ROW($1:$29),1)="单",ROW($2:$30)),ROW($1:$9)),COLUMN(A:I))*1,)+ROW($1:$9)*10^9,ROW($1:$9)*9),9)*1)
間隔需一空白{=SUM(IFERROR(--MID(SUBSTITUTE(SUBSTITUTE(D2," ",REPT(" ",99)),"单",REPT(" ",99)),ROW($1:$6)*99-98,99),))
留言
張貼留言