ROWS

How to use the Excel ROWS function to Get the number of rows in an array or reference.

Sponsored Link

Purpose 

Get the number of rows in an array or reference.

Return value 

A number representing row count.

Syntax 

=ROWS (array)

Arguments 

  • array - A reference to a cell or range of cells.

Usage notes 

Use ROWS to get the column count of a reference. For example, the formula =ROWS(A1:A10) returns the number 10.

Array can be an array, an array formula, or a reference to a single contiguous group of cells.

Sponsored Link

0 votes. 0 / 5