Manuals/calci/ROWS

ROWS(arr)

• where $arr$ is an array or reference

ROWS() displays the number of rows in an array or reference.

Description

ROWS(arr)

For Example,

ROWS(B4) returns 1.

• $arr$ can be a cell, range of cells or an array.

Examples

	ColumnA	ColumnB	ColumnC	ColumnD
Row1	2		3
Row2	5		7
Row3			9
Row4			11
Row5

=ROWS(D4)   : Calculates the row number of cell D4. Returns 4 as a result.
=ROWS(A2:C5): Calculates the row numbers in the range A2 to C5. Returns 4 as a result.
=ROWS({3,4;6,7;8,9}): Calculates the number of rows from the given array. Returns 3 as a result.

Related Videos

ROWS

See Also

• ROW

References

• Row