假设在ABC 3列
=SUMPRODUCT(($B$2:$B$100>=DATE(2010,12,31))*($B$2:$B$100
求2012年满足条件的人数:
=SUMPRODUCT((YEAR(B2:B9)=2012)*(C2:C9="A"))
=SUMPRODUCT((B1:B9>="2012-1-1")*(B1:B9<="2012-12-31")*(C1:C9="A"))
