<< Click to Display Table of Contents >> ROWS (number of rows in a range)

Syntax:

ROWS(Range)

Description:

This returns the number of rows in the specified cell range.

Example:

ROWS(A1:D5) returns 5

See also:

ROW, COLUMNS, AREAS