excel 中 A列大于某数且C列符合另一值的相加B列

Question

A列大于2015/6/30且C列为：品种A的，相加对应的B列值，用函数怎样实现？谢谢！

Answer 1

=SUMIFS(B:B,A:A,">2015/6/30",C:C,"品种A")

Answer 2

=SUMPRODUCT((A:A>DATE(2015,6,30))*(C:C="品种A"),B:B)