Excel数组countif公式 [英] Excel array countif formula

问题描述

我想使用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数组countif公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！