I have a table with 7-8 columns. I would like to place a field at the bottom of one of the columns that will tell me how many rows there are in the table. The problem I am having is that it does not seem to count rows with empty cells.
In this table, the top row is set as the header. The three middle rows contain data. The bottom row in my real table contains totals and averages. In this example, I've filled each cell in the bottom row with the formula: "{=count(above)-1}.
Code:
A B C D E F G H
1 2 2 3
1 2 2 3
1 2 2 3
3 2 1 0 2 0 1 2
The count seems to depend on how many cells are blank, but it is more complicated than that.
I would like all of the formulas to return "3", the number of rows in the table regardless of contents, excluding the header row.
How can I get it to do that?
I do not want to add another row with a sequence number or a numbered list.