比如：大於50=COUNTIF(資料區,">50")；小於50 =COUNTIF(資料區,"=50")；小於或等於50 =COUNTIF(資料區,""&$E$5)；大於或等於E5單元格的值 =COUNTIF(資料區,">="&$E$5)；小於或等於E5單元格的值 =COUNTIF(資料區,"10並且"&{10,15})*{1,-1}) 或者=SUM(COUNTIF(資料區,"=10並且="&{10,15})*{1,-1}) 或者 =SUM(COUNTIF(資料區,"=10並且=10",">15"})*{1,-1})(4)>10並且10",">=15"})*{1,-1})或者=SUM(COUNTIF(資料區,{">10","=60 =SUM(COUNTIF(INDIRECT({"a46:a48","b48:b50","c47:c48"}),">=60"))補充：（集合運演算法）統計範圍，比如5=5)-(x>7)寫為函式：=countif(range,">=5")-countif(range,">7")這樣就可以利用集合的運算知識了。同樣實現了上面兩個條件求個數相同的目的，並且更簡單易於理解。