Summary

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