軟體: excel
版本: 2010
目前遇到問題就是…
我如何針對我核取的項目 對應他所對應的數字來做加總?
我有截圖下來說明問題…
http://i.imgur.com/LyslUjO.jpg
檔案是: https://goo.gl/8o4h4x
還有…若我在p1頁 增加人數,是否可讓p2頁自動跟著增加?
和核取的過程可以改成核取方塊嗎?而不是輸入v來做核取
不好意思,我的問題好像有點多,
我好長一段時間沒碰excel了,
臨時交辦要做類似的東西,
希望有好心人可以教我怎麼弄,
或是有類似的範本可以讓我參考,
若這個牽扯到更專業的設計,
我願意負擔些學習費用!
非常謝謝喔!!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 101.13.71.118
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1489104091.A.0CC.html
→
03/10 08:13, , 1F
03/10 08:13, 1F
→
03/10 08:57, , 2F
03/10 08:57, 2F
→
03/10 08:57, , 3F
03/10 08:57, 3F
→
03/10 09:12, , 4F
03/10 09:12, 4F
→
03/10 09:13, , 5F
03/10 09:13, 5F
→
03/10 09:19, , 6F
03/10 09:19, 6F
→
03/10 09:27, , 7F
03/10 09:27, 7F
→
03/10 09:27, , 8F
03/10 09:27, 8F
→
03/10 09:27, , 9F
03/10 09:27, 9F
→
03/10 09:30, , 10F
03/10 09:30, 10F
→
03/10 09:32, , 11F
03/10 09:32, 11F
→
03/10 09:33, , 12F
03/10 09:33, 12F
→
03/10 09:38, , 13F
03/10 09:38, 13F
→
03/10 09:39, , 14F
03/10 09:39, 14F
→
03/10 09:42, , 15F
03/10 09:42, 15F
→
03/10 09:43, , 16F
03/10 09:43, 16F
→
03/10 09:46, , 17F
03/10 09:46, 17F
→
03/10 09:46, , 18F
03/10 09:46, 18F
→
03/10 09:46, , 19F
03/10 09:46, 19F
→
03/10 09:48, , 20F
03/10 09:48, 20F
→
03/10 09:48, , 21F
03/10 09:48, 21F
→
03/10 09:50, , 22F
03/10 09:50, 22F
→
03/10 09:50, , 23F
03/10 09:50, 23F
→
03/10 09:54, , 24F
03/10 09:54, 24F
→
03/10 09:54, , 25F
03/10 09:54, 25F
→
03/10 09:57, , 26F
03/10 09:57, 26F
→
03/10 10:03, , 27F
03/10 10:03, 27F
→
03/10 10:05, , 28F
03/10 10:05, 28F
→
03/10 10:06, , 29F
03/10 10:06, 29F
→
03/10 10:06, , 30F
03/10 10:06, 30F
→
03/10 10:12, , 31F
03/10 10:12, 31F
→
03/10 10:13, , 32F
03/10 10:13, 32F
→
03/10 10:14, , 33F
03/10 10:14, 33F
→
03/10 10:15, , 34F
03/10 10:15, 34F
→
03/10 10:16, , 35F
03/10 10:16, 35F
→
03/10 10:19, , 36F
03/10 10:19, 36F
→
03/10 10:46, , 37F
03/10 10:46, 37F
→
03/10 10:47, , 38F
03/10 10:47, 38F
→
03/10 11:02, , 39F
03/10 11:02, 39F