![Excel 添加多个值](https://linux22.com/image/1449031/Excel%20%E6%B7%BB%E5%8A%A0%E5%A4%9A%E4%B8%AA%E5%80%BC.png)
当“1”和“2”位于同一列时,如何将它们相加?
1
2
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
2
1
2
1
2
2
1
1
1
1
2
1
1
1
1
1
2
1
2
2
答案1
求和值 1:
=SUMIF(A1:A100;1;A1:A100)
求和值 2:
=SUMIF(A1:A100;2;A1:A100)