# ROW

## Content

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

## Syntax

`ROW(reference)`

## Arguments

[Optional] 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.

## Examples

`ROW(B2)` gives the result 2
`ROW(B1:B5)` gives the result 1