Manuals/calci/ROWS

ROWS(array)

• where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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.

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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