EXCEL数列中统计符合条件几个数的间隔次数和出现次数答:如图E2=SUM(--(FREQUENCY(IF(MMULT(--($A$1:$A$200={1,2,3,18,19}),ROW($1:$5)^0)>0,ROW($A$1:$A$200),""),IF(MMULT(--($A$1:$A$200={1,2,3,18,19}),ROW($1:$5)^0)=0,ROW($A$1:$A$200),""))=E1))-1按CTRL+SHIFT结束,F2=SUM(--(FREQUENCY(IF(...