ROWS

Returns the number of rows in a specified array or range.

Sample Usage

ROWS(C5:K25)

Syntax

ROWS(range)

  • range  - The range whose rows are to be counted. 

Examples

ROWS(C5:K25) returns the number of columns in the reference C5:K25 i.e. 21.