1311a 2011 10.14

设名称在A列,日期在B列,数量在D列
日期后插入一列C列 =MONTH(B115)
=SUMIFS(D114:D120,A114:A120,A114,C114:C120,"12")