计算某一区间数的个数的函数

给3个公式，计算大于-5且小于5的个数：

=sum(countif(a1:a10,{">-5",">=5"})*{1,-1})

=countif(a1:a10,">-5")-countif(a1:a10,">=5")

=sumproduct((a1:a10>-5)*(a1:a10<5))

求A1:A30范围内，数值等于255 和 331 的个数。

 

=SUM(COUNTIF(A1:A20,{"=255","=331"})*{1,1})

 

求A1:A30范围内，数值大于255小于331的个数

 

=SUM(COUNTIF(A1:A20,{">255",">=331"})*{1,-1})

 

求A1:A30范围内，数值小于255和大于或等于331的个数

 

=SUM(COUNTIF(A1:A20,{"<255",">=331"})*{1,1})