统计

lqyqing

问题如附件，刚才表格有误

zwzc

H2=SUM(INDEX(FILTER(DROP($B:$C,1),(YEAR(DROP($A:$A,1))=YEAR($G2))*(MONTH(DROP($A:$A,1))=MONTH($G2))),,COLUMN(A2)))
向下，向右
H4=SUM(INDEX(FILTER(DROP($B:$C,1),(YEAR(DROP($A:$A,1))=YEAR($G4))),,COLUMN(A4)))
向下，向右

hxj119

参考公式，其它公式类似

1. =SUMPRODUCT($B$2:$B$208*(TEXT($A$2:$A$208,"e年m月")=TEXT($G2,"e年m月")))

复制代码

quqiyuan

月份的：下拉右拉
=SUMIFS(B:B,$A:$A,">="&(EOMONTH($G2,-1)+1),$A:$A,"<="&(EOMONTH($G2,0)))
年度
=SUM(H$2:H3)