庄家大少 发表于 2021-10-23 15:44:00

求助按月份查找公式

公式中要求A-B的得数

瞎笔笔 发表于 2021-10-27 19:11:29

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)

下拉。

小兜兜的大兜兜 发表于 2021-12-2 15:54:41

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

一加一等于二 发表于 2021-12-3 08:08:56

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

易格 发表于 2021-12-16 20:49:59

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

吕春福 发表于 2022-1-2 20:02:40

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

清武鹰雄 发表于 2022-1-13 06:47:56

=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})

老男 发表于 2022-1-25 18:04:41

=SUMPRODUCT((MONTH($A$3:$A$11)=MONTH($G6))*($B$3:$B$11=$H$4)*($C$3:$C$11-$D$3:$D$11))
页: [1]
查看完整版本: 求助按月份查找公式