201901101506計算單件平均時間 (5274)

I3:L4=SUMPRODUCT(($A$2:$A$99=$H3)*B$2:B$99*$F$2:$F$99/TEXT(MMULT((0&$B$2:$E$99)*1,{1;1;1;1}),"0;;1"))/SUMIF($A$2:$A$99,$H3,B$2:B$99)

 

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





Powered by Xuite