B2{=SUM(IFERROR(MID(SUBSTITUTE(SUBSTITUTE(A2,"格","┋"),"┋",REPT(" ",99)),ROW($1:$5)*198-98,99)*1,))
另解=SUMPRODUCT(--TEXT(LEFT(TEXT(MID(SUBSTITUTE(A2&"〇","格",REPT(" ",66)),ROW($1:$666),66),),65),"0;;;!0"))
另解{=SUM(IFERROR(MID(TEXT(MID(SUBSTITUTE(A2,"┋",REPT(" ",9)),ROW($1:$99),9),),2,9)/1,))
留言
張貼留言