COUNTIF function. Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says:

下面是如何分别构造 AND 、 OR 和 NOT 函数的概述。. 当将它们分别与 IF 语句组合使用时，应按如下方式表达：. AND – =IF (AND (Something is True, Something else is True), Value if True, Value if False) OR – =IF (OR (Something is True, Something else is True), Value if True, Value if False)