<3000的和
=SUMIF(A:A,"<3000",B:B)
或
=SUMPRODUCT((A1:A2000<=3000)*B1:B2000)
>=3000<5000
=SUMIF(A:A,">=3000",B:B)-SUMIF(A:A,">=5000",B:B)
或
=SUMPRODUCT((A1:A2000>=3000)*B1:B2000)-SUMPRODUCT((A1:A2000>=5000)*B1:B2000)
>=5000<10000
=SUMIF(A:A,">=5000",B:B)-SUMIF(A:A,">=10000",B:B)
或
=SUMPRODUCT((A1:A2000>=5000)*B1:B2000)-SUMPRODUCT((A1:A2000>=10000)*B1:B2000)
温馨提示:答案为网友推荐,仅供参考