給3個公式，計算大于-5且小于5的個數(shù)：

=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范圍內(nèi)，數(shù)值等于255 和 331 的個數(shù)。

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

求A1:A30范圍內(nèi)，數(shù)值大于255小于331的個數(shù)

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

求A1:A30范圍內(nèi)，數(shù)值小于255和大于或等于331的個數(shù)

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