Numbers - Count rows on 2nd sheet

Hi VPermits

Numbers allows several tables on the "canvas" of every Sheet (Tab). Here is one sheet with two tables.

Formula in the single cell table on the left: ROWS(Table 1::A)

Add more rows to Table 1:

More information in the Function Browser:

Type = in any cell and type rows into the search box to see this:

Please call back with questions.

Regards,

Ian.

Provided the Table in which you want the rows counted has a Name that is not used by any other Table in the Document, the formula in Ian's single cell table can be placed on the same Sheet, or on any other Sheet in your Document.

In the example below, the single cell table, placed on Sheet 1of the Document, is named The Counter, and the second Table, named "Count My Rows", placed on Sheet 3 of the same Document.

"Count My Rows", in this example has no formulas. The formula shown below the table is in cell A1 (the only cell) of "The Counter", And is the same, except for the name of the Table on which the rows are being counted, as the formula in Ian's solution.

Adding a couple of rows to Count My Rows…

…immediately changes the count in The Counter.

Note also:

- Count My Rows has a Header row and initially 6, now 8 body rows. The second argument of ROWS can be set to include the Header row(s) or, as it is here, to ignore them when doing the count.

-ROWS count is independent of the data (or no data) content of the cells in the column it is counting.

Regards,

Barry

The ROWS formula will tell you how many rows are in a table.