C3{=SUM(IFERROR(MID(TEXT(MID(SUBSTITUTE(B3,",",REPT(" ",9)),ROW($1:99),9),),2,8)*1,))+SUM((MID(B3&",",ROW($2:99),1)=",")*ISERR(-MID(B3&",",ROW($1:98),1)))
英文字後面0 多算 1{=SUM(--TEXT(MID(TEXT(MID(SUBSTITUTE(B3&0,",",0&REPT(" ",9)),ROW($1:$99),10),),2,9),"0!.0;;1;!0"))
留言
張貼留言