求在2个日期之间的总和,还有其他条件!

差点无敌

请教老师!

丢丢表格

=SUM(SUMIFS(OFFSET(C:C,,{0,1}),A:A,F3,B:B,">="&G3,B:B,"<="&H3,OFFSET(D:D,,{0,1}),"="))




.

我的城市你来过

=SUMIFS($C$1:$C$19,A1:A19,F3,B1:B19,">="&G3,B1:B19,"<="&H3,D1:D19,"<>")

良良

=SUM((A2:A19=F3)*(B2:B19>=G3)*(B2:B19<=H3)*IF(D2:D19,D2:D19,C2:C19))

秃头发师

=SUM(FILTER(IF(D2:D19>0,D2:D19,C2:C19),(B2:B19>=G3)*(B2:B19<=H3)*(A2:A19=F3)))

栗子老湿

=SUMIFS(C2:C19,B2:B19,">="&G3,B2:B19,"<="&H3,A2:A19,F3)

差点无敌

丢丢表格 发表于 2023-3-25 18:38
=SUM(SUMIFS(OFFSET(C:C,,{0,1}),A:A,F3,B:B,">="&G3,B:B,"

如果f3只写简称,比如联通,怎么办呢?

差点无敌

良良 发表于 2023-3-25 19:10
=SUM((A2:A19=F3)*(B2:B19>=G3)*(B2:B19

如果f3只写简称,比如联通,怎么办呢?

浮生若梦~~~

=SUM(SUMIFS(C:C,A:A,F3,B:B,ROW(INDIRECT(G3&":"&H3)),D:D,"<>"))

浮生若梦~~~

差点无敌 发表于 2023-3-25 20:15
如果f3只写简称,比如联通,怎么办呢?

=SUM(SUMIFS(C:C,A:A,"*"&F3,B:B,ROW(INDIRECT(G3&":"&H3)),D:D,"<>"))