费用合计 (10934)


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,))


留言