[算表] SUMIF結果不對 只會加第一欄
軟體:EXCEL
版本:2010
A B C D E F G
1 甲 5 1 3 2 4 9
2 丙 0 3 5 7 1 6
3 甲 4 5 6 9 3 0
4 乙 3 5 7 5 9 8
5 乙 0 1 9 8 7 6
6 丙 6 1 3 8 5 7
7 甲 6 4 3 7 5 7
我想算"甲"的B~F加總是多少
=SUMIF(A1:A7,"甲",B1:F7)
可是不知道為什麼 答案只有15
不管範圍怎麼變,都只會算第一欄
還請各位幫忙解答,謝謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 220.128.148.61
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1402636042.A.8E0.html
→
06/13 13:15, , 1F
06/13 13:15, 1F
→
06/13 13:37, , 2F
06/13 13:37, 2F
→
06/13 13:40, , 3F
06/13 13:40, 3F
→
06/13 13:40, , 4F
06/13 13:40, 4F
→
06/13 13:43, , 5F
06/13 13:43, 5F
推
06/13 21:35, , 6F
06/13 21:35, 6F
→
06/13 21:35, , 7F
06/13 21:35, 7F
→
10/26 15:05, , 8F
10/26 15:05, 8F
→
10/26 15:05, , 9F
10/26 15:05, 9F
→
03/06 12:39, , 10F
03/06 12:39, 10F
→
03/06 12:40, , 11F
03/06 12:40, 11F