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?

Thank you in advance