計算多少單位 (10133)


C2{=SUM((0&LEFT(TRIM(MID(SUBSTITUTE(SUBSTITUTE(B2,"*",";"),";",REPT(" ",99)),ROW($1:$9)*198-197,99)),2))/20*(0&LEFT(TRIM(MID(SUBSTITUTE(SUBSTITUTE(B2,"*",";"),";",REPT(" ",99)),ROW($1:$9)*198-99,99)),2)))


留言