Countifs与复杂的标准 [英] Countifs with a complex criteria

问题描述

有没有可以在Excel中放置 count（）/ countif（）的复杂条件？ 复杂我的意思是包括和，或，其他逻辑操作及其组合。更简单的情况是和或或。例如，我想计算值小于3的值，或者等于 false 。

Is there an option to place a complex condition of count()/countif()in Excel? By "complex" I mean something that includes and, or, other logical operations and their combinations. The simpler case would be and or or only. For example I'd like to count those cells with value less than 3 or value equals to false.

推荐答案

在 countif （或 countifs ）中， OR 事务可以通过添加计算，例如

In a countif (or countifs), an OR transaction can be computed by addition, e.g.

=COUNTIF(range,"<3")+COUNTIF(range,FALSE)

一个 AND 事务不能轻易地在 COUNTIF ，但可以使用 COUNTIFS 或 SUMPRODUCT 进行管理，例如

An AND transaction can not easily be handled in a COUNTIF, but can be managed with either a COUNTIFS or a SUMPRODUCT, e.g.

=COUNTIFS(range,"<3",range,">1")

=SUMPRODUCT((range<3)*(range>1)*1)

这篇关于Countifs与复杂的标准的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！