ROWS then returns a final result of 100.
Note that the header row is not included in this count.
Related videos
Introduction to structured references
Formulas to query a table
Count table rows
To count rows in an Excel table, you can use the ROWS function. In the example shown, the formula in I4 is: =ROWS(Table1) The result is 100, since Table1 contains 100 rows of data.
