在SHEET2的B2中输入或复制粘贴下列公式
=SUMIFS(Sheet1!$C:$C,Sheet1!$A:$A,">="&DATE(2021,LEFT(B$1,LEN(B$1)-1),1),Sheet1!$A:$A,"<"&DATE(2021,LEFT(B$1,LEN(B$1)-1)+1,1),Sheet1!$B:$B,$A2)
或
=SUMIFS(SHEET1!$C:$C,SHEET1!$A:$A,">="&DATE(2021,COLUMN(C:C),1),SHEET1!$A:$A,"<"&DATE(2021,COLUMN(D:D),1),SHEET1!$B:$B,$A2)
下拉填充,右拉填充
温馨提示:答案为网友推荐,仅供参考