销售额合计 按年月 (11237)


K2:L13=SUMPRODUCT((TEXT($B$2:$H$20,"YYYMM")=K$1&TEXT($J2,0&0))*($B$1:$H$1="日期"),$A$2:$G$20)


留言