# Manuals/calci/ROW

Jump to navigation
Jump to search

**ROW (Array)**

- where is a cell or range of cells for which the row number is to be found.
- ROW(), returns the row number of a reference.

## Description

ROW(reference)

- For Example,ROW(B5)
*returns 5*as a result. - The function gives the row number of a cell specified or the function where it is placed.
- If is omitted, the function returns the row number of the cell where the function is written.

For Example, if the function is written in cell number 7, the function

ROW() *returns 7* as a result.

## Examples

ColumnA | ColumnB | ColumnC | ColumnD | |

Row1 | 2 | |||

Row2 | 5 | |||

Row3 | ||||

Row4 | ||||

Row5 |

=ROW(A3) : Calculates the row number of cell A3.Returns 3as a result. =ROW(A4:C4): Calculates the row number in the range A4 to C4.Returns 4as a result.

## Related Videos

## See Also

## References