excel求和 在公式中如何将日期作为筛选条件?

2025-03-17 13:33:35
推荐回答(4个)
回答1:

=SUMIF(AND($E$1:$E$50,"济南泺源",$G$1:$G$50>"2018/7/1"),$N$1:$N$50))

回答2:

=SUYMPROPDUCT((E3:E1000"济南泺源")*(G3:G1000>=DATE(2018.7.2))*(那:n1000))

回答3:

=SUMIFS(N:N,E:E,"济南泺源",G:G,">2018-7-1")

回答4:

=SUMIFS(N:N,E:E,"济南泺源",G:G,">2018-7-2")