问题描述:
在EXCEL中如何用SUMIF求多条件的总和,
A B C
编号 料号 数量
166592 R10.522263.S1N 1896
166592 R10.522263.S1N 1897
166593 R10.522263.S2N 1898
166593 R10.522263.S2N 1899
166593 R10.522263.S2N 1900
166593 R10.522263.S2N 1901
166593 R10.522263.S2N 1902
166593 R10.522263.S2N 1903
166593 R10.522263.S2N 1904
166593 R10.522263.S2N 1905
166592 R10.522263.S1N 1906
166592 R10.522263.S1N 1907
166592 R10.522263.S1N 1908
166592 R10.522263.S1N 1909
166592 R10.522263.S1N 1910
166592 R10.522263.S1N 1911
166592 R10.522263.S1N 1912
166592 R10.522263.S1N 10000
167674 R15.531205.U1N 10000
167674 R15.531205.U1N 10000
167674 R15.531205.U1N 10000
167674 R10.522263.S1N 10000
条件1是:"A1“,条件2是:B1.如何用SUMIF函数把上面的数量求和.
假设A1=167674, A2=167674,A3=167674,
B1= R10.522263.S1N
B2= R15.531205.U1N
B3=R15.531205.U1N
求出B1&B2&B3每个数量的和,答案放在D列
A B C
编号 料号 数量
166592 R10.522263.S1N 1896
166592 R10.522263.S1N 1897
166593 R10.522263.S2N 1898
166593 R10.522263.S2N 1899
166593 R10.522263.S2N 1900
166593 R10.522263.S2N 1901
166593 R10.522263.S2N 1902
166593 R10.522263.S2N 1903
166593 R10.522263.S2N 1904
166593 R10.522263.S2N 1905
166592 R10.522263.S1N 1906
166592 R10.522263.S1N 1907
166592 R10.522263.S1N 1908
166592 R10.522263.S1N 1909
166592 R10.522263.S1N 1910
166592 R10.522263.S1N 1911
166592 R10.522263.S1N 1912
166592 R10.522263.S1N 10000
167674 R15.531205.U1N 10000
167674 R15.531205.U1N 10000
167674 R15.531205.U1N 10000
167674 R10.522263.S1N 10000
条件1是:"A1“,条件2是:B1.如何用SUMIF函数把上面的数量求和.
假设A1=167674, A2=167674,A3=167674,
B1= R10.522263.S1N
B2= R15.531205.U1N
B3=R15.531205.U1N
求出B1&B2&B3每个数量的和,答案放在D列
问题解答:
我来补答展开全文阅读