excel表格如何能同时满足两列以上条件返回某一列的求和值，如图所示:

Answer 1

在F2输入
=SUM((C$2:C$8="代发")*(A$2:A$8=E2)*(B$2：B$8))
输入完成后，按下“Ctrl+Shift+Enter”组合键确认公式即可。

Answer 2

=sumproduct((a2:A8="上衣")*(C2:C8="代发").B2:B8)

Answer 3

=SUMIFS(B:B,A:A,E1,C:C,"代发")

直发的话在令一行把公式的”代发“换成直发

Answer 4

=sumproduct(($a$2:$A$8=E2)*($C$2:$C$8="代发")*$B$2:$B$8)