[發問] 請問一下，以下的公式能夠做簡化嗎？

509901

=資料總表!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,"澳條"))

主要是要做庫存的計算，想依照條件來做加減，該如何做？麻煩大大們教一下..謝謝!!

chen_cook

回復 1# 509901


    用定義名稱方式去做吧!!

509901

回復 2# chen_cook


   我試看看謝謝了