Excel ROWS function

Function              ROWS

Description        Excel ROWS function returns the number of rows in an array or reference

Syntax  ROWS(array)

array  Mandatory. A reference to a cell or range of cells or an array.

Example:

=ROWS(D2:F5) returns 4

= ROWS (C2:H15) returns 14

Related Video Tutorials: