本文介绍了Excel 数组计数公式的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我想使用 COUNTIF 函数来评估 2,0,0,5 中有多少项大于 2?在 Countif 函数中，第一个参数是范围，第二个参数是条件.我试过下面的公式.甚至尝试在最后使用 Ctrl+Shift+Enter 进行评估.但似乎不起作用.
I want to use COUNTIF function to evaluate how many items out of 2,0,0,5 are greater than 2? In Countif function, first argument is range and second is criteria. I have tried the below formula. Even tried using Ctrl+Shift+Enter at the end to evaluate. But doesn't seem to work.
=COUNTIF({"2","0","0","5"},">2")
推荐答案
COUNTIF 不接受数组常量(据我所知).试试这个:
COUNTIF doesn't accept array constants (as far as I know). Try this:
=SUMPRODUCT(--({2,0,0,5}>2))
您还可以创建一个像这样的 countif 样式的公式(组合 ctrl+shift+enter):
You could also create a countif-style formula like this (the combination ctrl+shift+enter):
=COUNT(IF({2,0,0,5}>2,1,""))
这篇关于Excel 数组计数公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！