Rows

Syntax

 Rows(Reference)

Parameters

Reference. Range reference.

Description

Returns the number of rows in reference.

Example

Formula Result Description
=Rows( A1:A11) 11 The number of rows in the range.

See also:

Function Wizard │ Search