Skip to Content

ROWS

Returns the number of rows in a reference or array

Syntax

ROWS(array)

Parameters

  • array: Required. An array, an array formula, or a reference to a range of cells

Example

=ROWS(A1:D5)
Returns: NumberSince: Excel 2003