求助

怎么没有人帮帮忙呢？

数据-筛选

用vba代码也可以，qq448733708.

=COUNTIFS(C2:C21,">=621",C2:C21,"<638")

=COUNTIFS(C2:C20,">=621",C2:C20,"<638")

F2=SUMPRODUCT((A$2:A$23>=--LEFT(F$1,6))*(A$2:A$23<=--RIGHT(F$1,6))*(C$2:C$23>=E2)*(C$2:C$23<E1)),下拉。

好像都不行，COUNTIFS我的excel没有，2010版本的还没有找到。

=COUNTIF(C2:C21,">=621",C2:C21,"<638")

F3输入sum(($a$2:$a$20>150900)*($a$2:$a$20<150921)*($c$2:$c$20<e2)*($c$2:$c$20>=e3))下拉，不知道对不对，没测试

sum(($a$2:$a$20>150900)*($a$2:$a$20<150921)*($c$2:$c$20<638)*($c$2:$c$20>=621))