中括號後面數字 加總 (13246)

日期：

C2{=SUM(IFERROR(MID(SUBSTITUTE(SUBSTITUTE(B2,"]","*"),"*",REPT(" ",99)),ROW($1:$9)*198-99,99)*1,))

D2{=SUM(IFERROR(MID(SUBSTITUTE(SUBSTITUTE(B2,"]","*"),"*",REPT(" ",99)),ROW($1:$9)*198-99,99)*MID(SUBSTITUTE(SUBSTITUTE(B2,"[","*"),"*",REPT(" ",99)),ROW($1:$9)*198,99)*1,))



留言

張貼留言