201906281118加總 有文字單位 (5790)

D7:F7{=TEXT(SUM(IF(ISERR(FIND("箱",D2:D6)),,LEFT(SUBSTITUTE(D2:D6,"箱",REPT(" ",9)),9))*1),"0箱;;")&IF(COUNT(FIND("箱",D2:D6)+FIND("瓶",D2:D6)),"+","")&TEXT(SUM(IF(ISERR(FIND("瓶",D2:D6)),,RIGHT(SUBSTITUTE(SUBSTITUTE(D2:D6,"瓶",),"+",REPT(" ",9)),9)*1)),"0瓶;;")

D8:F8{=SUM(LEFT(SUBSTITUTE(IF(ISERR(FIND("箱",D2:D6)),0,D2:D6),"箱","      "),6)*1)&"箱+"&SUM(RIGHT(SUBSTITUTE(SUBSTITUTE(IF(ISERR(FIND("瓶",D2:D6)),0,D2:D6),"箱+","      "),"瓶",),6)*1)&"瓶"

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank





Powered by Xuite