總和 依數字取得規定 (14901)

C2{=SUM(RIGHT(SMALL(IFERROR(MID(B2,SMALL(IF(MID(B2,ROW($1:$99),1)="*",ROW($1:$99)),{1,2,3})-ROW($1:$9),ROW($1:$9))*1,)+{1,2,3}*10^9,{1;2;3}*9),9)*1)+COUNT(0/TRIM(MID(SUBSTITUTE(B2,"+",REPT(" ",99)),ROW($1:$9)*99-98,99)))



留言