軟體:Excel
版本:2013
大家好:
假設有一50乘50的表格,儲存格裡都有數字,某些數字是紅色,某些數字是黑色。
我想個別計算紅色數字的總和和黑色數字的總和,請問有沒有比較有快速的方法?
謝謝回答!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 180.218.96.245
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1433310692.A.25D.html
→
06/03 14:07, , 1F
06/03 14:07, 1F
→
06/03 14:07, , 2F
06/03 14:07, 2F
→
06/03 14:32, , 3F
06/03 14:32, 3F
推
06/03 14:37, , 4F
06/03 14:37, 4F
→
06/03 14:45, , 5F
06/03 14:45, 5F
→
06/03 14:46, , 6F
06/03 14:46, 6F
→
06/03 14:46, , 7F
06/03 14:46, 7F
→
06/03 14:47, , 8F
06/03 14:47, 8F
→
06/03 18:18, , 9F
06/03 18:18, 9F
→
06/03 18:46, , 10F
06/03 18:46, 10F
→
06/03 19:15, , 11F
06/03 19:15, 11F
→
06/03 19:16, , 12F
06/03 19:16, 12F
→
06/03 19:22, , 13F
06/03 19:22, 13F
→
06/04 08:32, , 14F
06/04 08:32, 14F
→
06/04 08:47, , 15F
06/04 08:47, 15F
→
06/04 08:48, , 16F
06/04 08:48, 16F
→
06/04 08:49, , 17F
06/04 08:49, 17F
→
06/04 08:50, , 18F
06/04 08:50, 18F
→
06/04 08:50, , 19F
06/04 08:50, 19F
→
06/04 08:52, , 20F
06/04 08:52, 20F
→
06/04 08:52, , 21F
06/04 08:52, 21F
→
06/04 08:55, , 22F
06/04 08:55, 22F
→
06/04 08:56, , 23F
06/04 08:56, 23F
→
06/04 08:57, , 24F
06/04 08:57, 24F
→
06/04 09:01, , 25F
06/04 09:01, 25F