ROWS Function

The ROWS function is one of the lookup and reference functions. It is used to return the number of rows in a cell reference.

Syntax

ROWS(array)

The ROWS function has the following argument:

Argument Description
array A reference to a range of cells.

Notes

How to apply the ROWS function.

Examples

The figure below displays the result returned by the ROWS function.

ROWS Function