ROWS

See also A-Z Spreadsheet Function List

Description Returns the number of rows in a range reference.

Syntax ROWS(range)

range is a reference to a range of cells.

See Also COLUMNS and ROW functions

Examples ROWS(A1:D5) returns 5

         ROWS(C30:F35) returns 6