- 帖子
- 2
- 主題
- 1
- 精華
- 0
- 積分
- 50
- 點名
- 0
- 作業系統
- WIN7
- 軟體版本
- OFFICE 2007
- 閱讀權限
- 20
- 性別
- 男
- 來自
- 台灣
- 註冊時間
- 2012-2-29
- 最後登錄
- 2014-10-16
|
=資料總表!K2+(SUMIFS(每日異動!F:F,每日異動!B:B,"當日進貨",每日異動!D:D,"澳條"))-(SUMIFS(每日異動!F:F,每日異動!B:B,"原料解凍",每日異動!D:D,"澳條"))+(SUMIFS(每日異動!F:F,每日異動!B:B,"生產退料",每日異動!D:D,"澳條"))-(SUMIFS(每日異動!F:F,每日異動!B:B,"全日入庫",每日異動!D:D,"澳條"))+(SUMIFS(每日異動!F:F,每日異動!B:B,"全日出庫",每日異動!D:D,"澳條"))-(SUMIFS(每日異動!F:F,每日異動!B:B,"異常領料",每日異動!D:D,"澳條"))+(SUMIFS(每日異動!F:F,每日異動!B:B,"分切入庫",每日異動!D:D,"澳條"))+(SUMIFS(每日異動!F:F,每日異動!B:B,"成品入庫",每日異動!D:D,"澳條"))-(SUMIFS(每日異動!F:F,每日異動!B:B,"退庫重製",每日異動!D:D,"澳條"))-(SUMIFS(每日異動!F:F,每日異動!B:B,"亞太入庫",每日異動!D:D,"澳條"))+(SUMIFS(每日異動!F:F,每日異動!B:B,"亞太出庫",每日異動!D:D,"澳條"))-(SUMIFS(每日異動!F:F,每日異動!B:B,"牧昌入庫",每日異動!D:D,"澳條"))+(SUMIFS(每日異動!F:F,每日異動!B:B,"牧昌出庫",每日異動!D:D,"澳條"))
主要是要做庫存的計算，想依照條件來做加減，該如何做？麻煩大大們教一下..謝謝!! |
|
發表於 2012-3-30 23:50
| 
