excel该怎么统计某个时间段内的出现次数

sum+countifs就可以

亲，找一个空白单元格，粘贴这个公式：
=SUMPRODUCT(($F$1:$F$5000>="07:00")*($F$1:$F$5000<="09:00"))+SUMPRODUCT(($G$1:$G$5000>="11:00")*($G$1:$G$5000<="12:00"))+SUMPRODUCT(($H$1:$H$5000>="17:00")*($H$1:$H$5000<="18:00"))

　　=SUMPRODUCT((A2:A1000>=0.583)*(A2:A1000<=0.708))

=SUMIFS(B:B,A:A,">=8:30",A:A,"<8:45")
或=SUMPRODUCT((A1:A99>=--"8:30")*(A1:A99<--"8:45")*B1:B99)

=SUMIFS(B:B,A:A,">=8:45",A:A,"<9:00")
或=SUMPRODUCT((A1:A99>=--"8:45")*(A1:A99<--"9:00")*B1:B99)
.
.
.

设数“成功"在A列，时间在B列。以2—3分钟为例，用公式：
=COUNTIFS($B$2:$B$100,"<=0:03:00",$B$2:$B$100,">0:02:00",$A$2:$A$100,"成功")

用程序解决你的问题应该能够符合要求
Sub abcd()For i = 1 To [A65536].End(xlUp).Rowa = Cells(i, 1)If i = 1 Then b = a If a - b > 8.33333333333334E-02 Then Cells(i - 1, 3) = b: Cells(i - 1, 4) = Cells(i - 1, 1) Cells(i - 1, 5) = t: Cells(i - 1, 6) = c Range(Cells(i - 1, 3), Cells(i - 1, 4)).NumberFormatLocal = "h:mm:ss;@" b = Cells(i, 1): i = i - 1: t = 0: c = 0 Else t = t + 1 c = c + Cells(i, 2) d = a - b End IfNext Cells(i - 1, 3) = b: Cells(i - 1, 4) = Cells(i - 1, 1) Cells(i - 1, 5) = t: Cells(i - 1, 6) = c Range(Cells(i - 1, 3), Cells(i - 1, 4)).NumberFormatLocal = "h:mm:ss;@" b = Cells(i, 1)End Sub

最简单的一个命令是
cat a.log |grep "str123" |wc -l

如果是某个文件夹内的，
就可以到这个文件夹后
cat *.* |grep "str123" |wc -l

如下图，在D1~D5依次为1分钟内、1-2分钟内、2-3分钟内........D1的公式如下，下拉至D5：=SUMPRODUCT(($B$1:$B$12>=(ROW($A1)-1)/60/24)*($B$1:$B$12<ROW($A1)/60/24))