ROWS

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

ROWS

Summary 

The Excel ROWS function returns the count of rows in a given reference. 

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(B1:B10) returns the number 10.

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

0 votes. 0 / 5