How to count the number of lines when some cells in a column contain multiple lines? Example:
+----------------------+
| text |
+----------------------+
| multiline |
| text |
| here |
+----------------------+
| |
+----------------------+
| some cells are empty |
+----------------------+
The function counta
helps by counting nonempty cells, but it does not take into account multiple lines in the same cell.