假设数据在A~C列(下次截图请带上行列号!)=sumproduct(($A$3:$A$100=date(2013,5,1))*($C$3:$C$100="男"))+sumproduct(($A$3:$A$100=date(2013,5,4))*($C$3:$C$100="男"))+sumproduct(($A$3:$A$100=date(2013,5,9))*($C$3:$C$100="男"))+sumproduct(($A$3:$A$100=date(2013,5,13))*($C$3:$C$100="男"))另外,这4个日期是根据什么得出的?如果没有规律,只能用上面的死办法。...
|