加總 星號前數字 (9133)


C2{=SUM((0&TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"*",";"),";",REPT(" ",499)),ROW(1:99)*999-998,499)))*1)


另解{=SUM(IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"*",";"),";",REPT(" ",499)),ROW(1:99)*499-498,499))*1,))


留言