## ROW Function

Written by kazamraza
no comments

Classified in : Excel Formulas, Lookup Functions

## Syntax

```
ROW([reference])
```

The ROW function syntax has the following arguments:

- Reference Optional. The cell or range of cells for which you want the row number.
- If reference is omitted, it is assumed to be the reference of the cell in which the ROW function appears.
- If reference is a range of cells, and if ROW is entered as a vertical array, ROW returns the row numbers of reference as a vertical array.
- Reference cannot refer to multiple areas.

◢ | A | B | C | D | E |
---|---|---|---|---|---|

1 | Formula |
Description |
Result |
||

2 | =ROW() | Row in which the formula appears | 2 | ||

3 | =ROW(C10) | Row of the reference | 10 | ||

4 |