Definition of ROW:
Returns the row number of a specified cell.
cell_reference- [ OPTIONAL - The cell in which the formula is entered by default ] - The cell whose row number will be returned.
cell_referenceis a range more than one cell wide and the formula is not used as an array formula, only the numeric value of the first row in
ROWS: Returns the number of rows in a specified array or range.
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 ROW Formula, start with the Excellentable you would like to edit.
Step 2. Then type the ROW formula into the cell you have chosen to display the outcome:
Step 3. Fill in the value.
By adding the values you would like to calculate, Excellentable generates the outcome: