请教大神，Excel怎么通过IF筛选大于等于某个单元格里面的时间段

都瑞米2009

用excel计算销售本月时间段的成绩，而每个月都得筛选本月
原本的公式中
=SUM(SUMIFS($P:$P,$C:$C,"小明",$B:$B,">=1/11/2019",$B:$B,"<=31/11/2019",$F:$F,{"New","Upsell"}))

请问能否每个月自动筛选本月时间段的？时间段是B:B
如果很复杂，可以再某个单元格A1输入1/11/2019，A2输入31/11/2019，但这样代入公式也是错误，请教大神帮忙
=SUM(SUMIFS($P:$P,$C:$C,"小明",$B:$B,">=A1",$B:$B,"<=A2",$F:$F,{"New","Upsell"}))

静看流年RSSQ

=SUM(SUMIFS($P:$P,$C:$C,"小明",$B:$B,">="&A1,$B:$B,"<="&A2,$F:$F,{"New","Upsell"}))

这样试一下，或者上个附件。大概就是这样改的。

都瑞米2009

静看流年RSSQ 发表于 2019-11-8 13:08
=SUM(SUMIFS($P:$P,$C:$C,"小明",$B:$B,">="&A1,$B:$B,"

学习了，非常感谢你