求助按月份查找公式

庄家大少

公式中要求A-B的得数
工作簿.rar (10.29 KB, 下载次数: 33)

2021-10-23 15:44 上传

点击文件名下载附件
工作簿.rar

瞎笔笔

H6=SUMIFS(C:C,B:B,$H$4,A:A,"<="&G6,A:A,">="&EOMONTH(G6,-1)+1)-SUMIFS(D:D,B:B,$H$4,A:A,"<="&G6,A:A,">="&EOMONTH(G6,-1)+1)

下拉。

小兜兜的大兜兜

蒙一个
=SUM(($A$3:$A$11<=G6)*($B$3:$B$11=$H$4)*($C$3:$C$11-$D$3:$D$11))
三键结束，下拉

一加一等于二

公式：=SUMPRODUCT((TEXT(A$3:A$100,"emm")=TEXT(G6,"emm"))*(B$3:B$100=H$4)*(C$3:C$100-D$3:D$100))

工作簿.rar (10.24 KB, 下载次数: 11)

2021-10-23 15:44 上传

点击文件名下载附件
工作簿.rar

易格

=SUMPRODUCT(SUMIFS(OFFSET(C:C,,{0;1}),B:B,H$4,A:A,{">",">"}&EDATE(G6,{-1,0}))*{1,-1;-1,1})

吕春福

=SUMPRODUCT((MONTH(A$3:A$11)=MONTH(G6))*(B$3:B$11=H$4)*(C$3:D$11)*{1,-1})

清武鹰雄

=SUM((TEXT(N(+A:A),"emm")=TEXT(G6,"emm"))*(B:B=H$4)*N(+C:D)*{1,-1})
=SUM(SUMIFS(OFFSET(B:B,,{1,2}),A:A,"<="&G6,A:A,">"&EOMONTH(G6,-1),B:B,H$4)*{1,-1})

老男

=SUMPRODUCT((MONTH($A$3:$A$11)=MONTH($G6))*($B$3:$B$11=$H$4)*($C$3:$C$11-$D$3:$D$11))