[問題] EXCEL-出現#VALUE,不知問題出在哪
軟體:EXCEL
版本:2007
文件中,紅色框的部分不知是哪個儲存格出錯導致#VALUE。
(本懷疑係因要加總的儲存格有"空白",但是!!
藍色框部分也有加總儲存格是空白阿,卻可以運算)
附上檔案:
https://www.dropbox.com/s/s0lxazgk7xktqaf/TEST.xls?dl=0
*已檢查過了,加總的儲存格皆非文字格式。
用SUM可以免除錯誤出現,但仍想知道各別加為啥會出現#VALUE。
感謝各位大大THX!!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 60.248.127.174
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1462528777.A.F55.html
※ 編輯: lybarboola (60.248.127.174), 05/06/2016 18:11:31
→
05/06 18:24, , 1F
05/06 18:24, 1F
→
05/06 18:24, , 2F
05/06 18:24, 2F
→
05/06 19:24, , 3F
05/06 19:24, 3F
→
05/06 19:25, , 4F
05/06 19:25, 4F
→
05/06 19:27, , 5F
05/06 19:27, 5F
→
05/06 19:28, , 6F
05/06 19:28, 6F
→
05/06 19:38, , 7F
05/06 19:38, 7F
→
05/06 19:38, , 8F
05/06 19:38, 8F
→
05/06 19:40, , 9F
05/06 19:40, 9F
→
05/06 19:45, , 10F
05/06 19:45, 10F
→
05/06 19:47, , 11F
05/06 19:47, 11F
→
05/06 22:11, , 12F
05/06 22:11, 12F
→
05/06 22:12, , 13F
05/06 22:12, 13F
→
05/06 22:13, , 14F
05/06 22:13, 14F
→
05/06 22:15, , 15F
05/06 22:15, 15F
→
05/06 22:16, , 16F
05/06 22:16, 16F
→
05/06 22:16, , 17F
05/06 22:16, 17F
→
05/06 22:37, , 18F
05/06 22:37, 18F