=SUMIFS(C:C,A:A,">=2014-1-1",A:A,"<=2014-1-7",B:B,"苹果")这个公式可以解决你的问题,你试试看!
用公式：=SUMPRODUCT((A$1:A$16>="2014-01-01")*(A$1:A$16<="2014-01-07")*(B$1:B$16="苹果")*C$1:C$16)
