求助一个COUNTIFS公式

yueting0413

老师们晚上好！
          求助一个COUNTIFS的公式，谢谢老师

uneye2

=COUNTIFS(B:B,F5,D:D,">="&$G$3,D:D,"<="&$H$3)

yueting0413

uneye2 发表于 2024-8-17 20:49
=COUNTIFS(B:B,F5,D:D,">="&$G$3,D:D,"

谢谢老师，我就是不明白要加个&才能实现。感谢指点！

mjm04

用这个

=COUNTIFS($D$4:$D$22,">="&$G$3,$D$4:$D$22,"<="&$H$3,$B$4:$B$22,$F5)


其实还有好几个函数可以满足你的需求的：

=SUMPRODUCT(($D$4:$D$22>=$G$3)*($D$4:$D$22<=$H$3)*($B$4:$B$22=$F5))

=SUM(MMULT(($D$4:$D$22>=$G$3)*($D$4:$D$22<=$H$3)*($B$4:$B$22=$F5),1))

=ROWS(FILTER($C$4:$C$22,($D$4:$D$22>=$G$3)*($D$4:$D$22<=$H$3)*($B$4:$B$22=$F5)))

IF大法也是可以的呢
=SUM(IF(($D$4:$D$22>=$G$3)*($D$4:$D$22<=$H$3)*($B$4:$B$22=$F5),ROW($1:$19)^0,""))



写这些只是想说，解决问题的不是只能用一个函数，思路要开阔些呢；

yueting0413

mjm04 发表于 2024-8-17 20:54
用这个

=COUNTIFS($D$4:$D$22,">="&$G$3,$D$4:$D$22,"

感谢感谢感谢！我会下载收藏学习！