商品 * 數量字符串 計總價 (15024)

日期：

D3{=SUM(IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(C3,CHAR(10),"*"),"*",REPT(" ",99)),ROW($1:$9)*198-99,99))*VLOOKUP(T(IF({1},TRIM(MID(SUBSTITUTE(SUBSTITUTE(C3,CHAR(10),"*"),"*",REPT(" ",99)),ROW($1:$9)*198-197,99)))),G:H,2,),))



留言

張貼留言