计算不为空值的行 [英] Count rows with not empty value

问题描述

在Google电子表格中:如何计算给定区域中具有值的行?到目前为止，我发现的所有提示都导致公式计算包含非空内容(包括公式)但具有

In a Google Spreadsheet: How can I count the rows of a given area that have a value? All hints about this I found up to now lead to formulas that do count the rows which have a not empty content (including formula), but a cell with

=IF(1=2;"";"")  // Shows an empty cell

也算在内.

此简单任务的解决方案是什么?

What is the solution to this simple task?

推荐答案

使用函数"CountBlank"使另一列确定引用的单元格是否为空白.然后对新的"CountBlank"列中创建的值使用count.

Make another column that determines if the referenced cell is blank using the function "CountBlank". Then use count on the values created in the new "CountBlank" column.

这篇关于计算不为空值的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！