All functions / Lookup

ROWS

How many rows a range has.

Syntax

=ROWS(array)

Arguments

• array: A range or array.

Example

=ROWS(A2:A11) → 10

Practise it

• Finding duplicates