EXCEL中，不同条件下两列的求和？

E2公式：
=SUMPRODUCT((A2:A999="A")*(B2:B999>--"11-22")*C2:C999)+SUMIF(A2:A999,"A",D2:D999)

如果是EXCEL 2007及以上版本，公式可以精简为这样：
=SUMIFS(C:C,A:A,"A",B:B,">"&--"11-22")++SUMIF(A:A,"A",D:D)

用下面的公式：
=SUMIFS(C:C,A:A,"A",B:B,">2014-11-22")+SUMIF(A:A,"A",D:D)

用公式：
=SUMIFS(D$2:D$100,A$2:A$100,"A",B$2:B$100,">"&DATEVALUE("11-22"))+SUMIF(A$2:A$100,"A",D$2:D$100)
或：
=SUMPRODUCT((A$2:A$100="A")*(B$2:B$100>"11-22")*D$2:D$100)+SUMIF(A$2:A$100,"A",D$2:D$100)

E2输入=SUMPRODUCT((A2:A100="A")*(B2:B100>B2)*(C2:C100))+SUMPRODUCT((A2:A100="A")*(D2:D100))
=SUMPRODUCT((A2:A100="A")*(B2:B100>11-22)*(C2:C100))+SUMPRODUCT((A2:A100="A")*(D2:D100))

=SUMIF(A:A,"A",C:C)+SUMIF(B:B,">11月22",D:D)
下拉填充公式