Navigation:  Formula Reference > Spreadsheet Formula Functions >

ROW

Previous pageReturn to chapter overviewNext page

 

This function returns the number of a row from a reference.

Syntax

ROW(reference)

Arguments

The argument is a cell or a single area.

Remarks

If the reference is omitted, the reference of the cell that the function is in is used.

Data Types

Accepts a cell or a single area. Returns numeric data.

Examples

ROW(B2) gives the result 2

ROW(B1:B5) gives the result 1

 

See Also

COLUMNS

INDEX