Getting the Count formula to count all rows

Jennifer Murphy · #1 08-22-2016, 10:40 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a formula to count all occurances of HH but multiply by 0.5 first	stupidgirl	Excel	6	06-14-2016 03:50 PM
simple way to count rows in a table?	bkcell	Word	4	03-09-2015 09:06 PM
Word Count Formula	clau_dos	Word VBA	1	08-27-2013 02:05 PM
Count rows and add blank rows accordingly	Hoochtheseal	Word VBA	1	01-29-2013 09:23 PM
Count If Formula	beb1227	Excel	10	06-19-2011 11:19 AM