ROWS function

Category: Lookup and reference functions

What does this function do?

Returns the number of rows in an array or reference.

Syntax:

ROWS(array)

• Array: An array or array formula, or a reference to a range of cells for which you want the number of rows.

Examples:

=ROWS(B2:C5)=4

=ROWS(C7:F10)=4