Skip to main content


 Definition of ROWS:

Returns the number of rows in a specified array or range.

Sample Usage





  • range - The range whose row count will be returned

See Also

ROW: Returns the row number of a specified cell.

COLUMNS: Returns the number of columns in a specified array or range.

COLUMN: Returns the column number of a specified cell, with `A=1`.


Step 1. To use the ROWS Formula, start with the Excellentable you would like to edit.



Step 2. Then type the ROWS formula into the cell you have chosen to display the outcome:

Step 3. Fill in the 1 required value.


By adding the values you would like to calculate, Excellentable generates the outcome:




User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.