Manuals/calci/ROWS

ROWS(array)

• where $array$ is an array or reference

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

Description

ROWS(array)

For Example,

ROWS(B4) returns 1.

• $array$ 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 number in the range A2 to C5. Returns 4 as a result.

See Also

• ROW

References

• Row