Search code examples
google-sheetsgoogle-sheets-formula

Count rows with not empty value

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

is counted as well.

What is the solution to this simple task?

Solution

  • 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.