ROWS

MS Excel Spreadsheet

See Also

Returns the number of rows in a reference or array.

Syntax

ROWS(array)

Array    is an array, an array formula, or a reference to a range of cells for which you want the number of rows.

Example

The example may be easier to understand if you copy it to a blank spreadsheet.

ShowHow?

Formula Description (Result)
=ROWS(C1:E4) Number of rows in the reference (4)
=ROWS({1,2,3;4,5,6}) Number of rows in the array constant (2)