怎么求区间内的数字，出现了几次？

如图，给我一个公式吧！谢谢！！我要统计按日期（我这里设置是常规格式）标注的，自动统计出对应多少人的人数！一个公式解决一件事哦！！

2026年09月29日 03:15

有3个网友回答

网友（1）：

L3=(COUNTIF(D3:D12,">=0")-COUNTIF(I3:I12,">6.9"))+(COUNTIF(D3:D12,">=0")-COUNTIF($PI3:I12,">6.9"))
--------------------------------------
L4=(COUNTIF(D3:D12,">=8")-COUNTIF(I3:I12,">11.9"))+(COUNTIF(D3:D12,">=8")-COUNTIF($PI3:I12,">11.9"))
--------------------------------------
L5=(COUNTIF(D3:D12,">=12")-COUNTIF(I3:I12,">26.9"))+(COUNTIF(D3:D12,">=12")-COUNTIF($PI3:I12,">26.9"))
--------------------------------------
L6=(COUNTIF(D3:D12,">=27.1")-COUNTIF(I3:I12,">28.9"))+(COUNTIF(D3:D12,">=27.1")-COUNTIF($PI3:I12,">28.9"))
--------------------------------------
L7=(COUNTIF(D3:D12,">=28.1")-COUNTIF(I3:I12,">29.9"))+(COUNTIF(D3:D12,">=28.1")-COUNTIF($PI3:I12,">29.9"))
--------------------------------------
L8=(COUNTIF(D3:D12,">=29.1")-COUNTIF(I3:I12,">30.9"))+(COUNTIF(D3:D12,">=29.1")-COUNTIF($PI3:I12,">30.9"))

网友（2）：

542光∝¾≥X近5等于4336光年办

网友（3）：

=SUMPRODUCT(ROW(1:100)