某一时间段多条件求和

XUYUJING2007 · 发表于 2024-7-27 14:14

=SUMIFS(D:D,A:A,">="&H1,A:A,"<="&I1,B:B,J1,C:C,K1&"*")+SUMIFS(D:D,A:A,">="&H1,A:A,"<="&I1,B:B,J1,C:C,L1&"*")

daocaoren · 发表于 2024-7-27 14:18

沈默00 发表于 2024-7-27 14:10
=SUM(SUMIFS(D:D,B:B,"华东",C:C,{"手机*","电脑*"},A:A,">="&"2024/1/1",A:A,"

如果是华东和东北地区呢？两个地区。

沈默00 · 发表于 2024-7-27 14:19

=SUM(FILTER(D2:D18,(MONTH(A2:A18)<3)*((LEFT(C2:C18)="手")+(LEFT(C2:C18)="电"))*((B2:B18="华东")+(B2:B18="东北")))) 华东+东北的

daocaoren · 发表于 2024-7-27 14:25

沈默00 发表于 2024-7-27 14:19
=SUM(FILTER(D2:D18,(MONTH(A2:A18)

谢谢解惑。

我的城市你来过 · 发表于 2024-7-27 15:18

=SUM(SUMIFS($D:$D,$A:$A,">=2024/01/01",$A:$A,"<=2024/02/28",$B:$B,"华东",$C:$C,{"手机*","电脑*"}))

		自动登录	找回密码
密码			免费注册

[已解决] 某一时间段多条件求和