如图,想要统计每个月的销售额,E2公式:
=SUMPRODUCT((IF((DAY($A$2:$A$9960)>=26)*(MONTH($A$2:$A$9960)<12),YEAR($A$2:$A$9960)&"年"&MONTH($A$2:$A$9960)+1&"月",IF((DAY($A$2:$A$9960)>=26)*(MONTH($A$2:$A$9960)=12),YEAR($A$2:$A$9960)+1&"年"&"1月",YEAR($A$2:$A$9960)&"年"&MONTH($A$2:$A$9960)&"月"))=E3)*$B$2:$B$9960)
ctrl+shift+enter,下拉(E列月份需为文本格式)