=SUMPRODUCT((C2:C100>=DATE(2014,11,4))*(C2:C100<=DATE(2014,11,9))*(D2:D100="满足"))+SUMPRODUCT((C2:C100="未出图")*(D2:D100="满足"))
=SUMPRODUCT(((C2:C200>=DATEVALUE("2014-11-4"))*(C2:C200<=DATEVALUE("2014-11-9"))+(C2:C200="未出图"))*(D2:D200="满足"))
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024