[算表] A欄及B欄都不為零時 加總C欄
軟體:EXCEL
版本:2010
如標題, 使用
SUMIFS(C1:C5,A1:A5,"<>",B1:B5,"<>")
但計算結果是#VALUE
請問要如何修正呢?
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 59.126.201.124
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1494923140.A.85A.html
→
05/16 16:31, , 1F
05/16 16:31, 1F
→
05/16 16:31, , 2F
05/16 16:31, 2F
→
05/16 16:37, , 3F
05/16 16:37, 3F
→
05/16 16:38, , 4F
05/16 16:38, 4F
→
05/16 16:56, , 5F
05/16 16:56, 5F
→
05/16 16:56, , 6F
05/16 16:56, 6F
→
05/16 16:57, , 7F
05/16 16:57, 7F
→
05/16 17:02, , 8F
05/16 17:02, 8F
→
05/16 17:02, , 9F
05/16 17:02, 9F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
