[算表] 用VBA語法寫SUMIF函數
軟體: excel
版本: 2007、2010
我有一個編輯用表 : http://ppt.cc/n~~y
還有一個進貨數量表 : http://ppt.cc/OSH-
因為每天都需要把進貨數量KEY進編輯用表裡
但進貨數量表每天都會有新的一份,
且數量會增增減減,項目也會不定期增加、減少
同一個貨品進貨的數量可能分成兩筆或兩筆以上的項目
要每天一個一個輸入實在太花時間了
目前是每天用SUMIF函數在統計
但每天也還是要花一小時左右處理
還是希望可以用VBA語法寫SUMIF函數
不過不曉得該怎麼寫QQ
不曉得有沒有人可以幫幫忙 ?
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 220.136.28.195
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1402757584.A.6C8.html
→
06/14 23:23, , 1F
06/14 23:23, 1F
→
06/14 23:26, , 2F
06/14 23:26, 2F
→
06/14 23:26, , 3F
06/14 23:26, 3F
→
06/14 23:50, , 4F
06/14 23:50, 4F
→
06/14 23:50, , 5F
06/14 23:50, 5F
→
06/14 23:52, , 6F
06/14 23:52, 6F
→
06/14 23:55, , 7F
06/14 23:55, 7F
→
06/14 23:57, , 8F
06/14 23:57, 8F
→
06/14 23:57, , 9F
06/14 23:57, 9F
→
06/14 23:58, , 10F
06/14 23:58, 10F
→
06/15 00:00, , 11F
06/15 00:00, 11F
→
06/15 00:00, , 12F
06/15 00:00, 12F
→
06/15 00:01, , 13F
06/15 00:01, 13F
→
06/15 00:04, , 14F
06/15 00:04, 14F
→
06/15 00:05, , 15F
06/15 00:05, 15F
→
06/15 00:05, , 16F
06/15 00:05, 16F
→
06/15 00:11, , 17F
06/15 00:11, 17F
→
06/15 00:13, , 18F
06/15 00:13, 18F
→
06/15 00:20, , 19F
06/15 00:20, 19F
→
06/15 00:20, , 20F
06/15 00:20, 20F
→
06/15 00:22, , 21F
06/15 00:22, 21F
→
06/15 00:22, , 22F
06/15 00:22, 22F
→
06/15 00:23, , 23F
06/15 00:23, 23F
→
06/15 00:24, , 24F
06/15 00:24, 24F
→
06/15 00:24, , 25F
06/15 00:24, 25F
→
06/15 00:24, , 26F
06/15 00:24, 26F
→
06/15 00:24, , 27F
06/15 00:24, 27F
→
06/15 00:26, , 28F
06/15 00:26, 28F
→
06/15 00:27, , 29F
06/15 00:27, 29F
→
06/15 00:29, , 30F
06/15 00:29, 30F
→
06/15 00:29, , 31F
06/15 00:29, 31F
→
06/15 00:30, , 32F
06/15 00:30, 32F
→
06/15 00:30, , 33F
06/15 00:30, 33F
→
06/15 00:34, , 34F
06/15 00:34, 34F
→
06/15 00:34, , 35F
06/15 00:34, 35F
→
06/15 00:36, , 36F
06/15 00:36, 36F
→
06/15 00:37, , 37F
06/15 00:37, 37F
→
06/15 00:38, , 38F
06/15 00:38, 38F
→
06/15 00:39, , 39F
06/15 00:39, 39F
→
06/15 01:13, , 40F
06/15 01:13, 40F
→
06/15 01:33, , 41F
06/15 01:33, 41F
→
06/15 01:36, , 42F
06/15 01:36, 42F