Question

EXCEL中设定A列和B列特定值两个条件，在C列求和

如图：求满足A列＝2、B列＝A这两个条件的C列数字之和

Answer 1

=SUMIFS(C1:C8,A1:A8,"=2",B1:B8,"=A")

Answer 2

D1输入下面公式得出结果。
=SUMPRODUCT(--(A:A=2),--(B:B="A"),C:C)

Answer 3

=SUMPRODUCT((A1:A8=2)*(B1:B8="A"),C1:C8)

Answer 4

=SUMIFS(C:C,A:A,2,B:B,A)

Answer 5

sumifs
sumproduct都可以。