ROWS

 Definition of ROWS:

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

Sample Usage

ROWS(A9:A62)

ROWS({1;2;3;4;5})

Syntax

ROWS(range)

• 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: