统计出现次数

半杯中药

统计出现次数，求助
求助111.zip (8.03 KB, 下载次数: 172)

2021-10-30 17:05 上传

点击文件名下载附件
求助111.zip

昂

=COUNT(MATCH(ROW(INDIRECT(D5&":"&E5)),A:A,))

一生的爱

=COUNT(UNIQUE(FILTER(A$5:A$100,(A$5:A$100>=D5)*(A$5:A$100<=E5))))

幸运妹妹

F5=SUMPRODUCT((A$5:A$100>=D5)*(A$5:A$100<=E5)/COUNTIF(A$5:A$100,A$5:A$100&""))

下拉。

少年的你

这样？？
=COUNT(0/IF(MATCH($A$5:$A$31,IF(($A$5:$A$98>=D5)*($A$5:$A$98<=E5),$A$5:$A$31,0),0)=ROW($A$5:$A$31)-4,ROW($A$5:$A$31)))

娱乐汇五哥

数组公式
=SUM(IF(FREQUENCY(IF(($A$5:$A$100>=D5)*($A$5:$A$100<=E5),$A$5:$A$100),$A$5:$A$100),1))

赵均发

=COUNTIFS($A$5:$A$33,">="&D5,$A$5:$A$33,"<="&E5)