在C2单元格输入公式
=sum((A2:A100="甲")*(B2:B100<=10))
然后Shift+Ctrl+Enter
B2
=sum((A2:A100="甲")*(B2:B100<=5))
C2
=sum((A2:A100="甲")*(B2:B100>=7))
几个一定要Shift+Ctrl+Enter
C2
=SUMPRODUCT((A2:A100="甲")*(B2:B100<=10))
D2
=SUMPRODUCT((A2:A100="甲")*(B2:B100<=5))
Excel多条件求和 & SUMPRODUCT函数用法详解
http://club.excelhome.net/forum.php?mod=viewthread&tid=663536&extra=&highlight=&page=1
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024