Excel ROWS Function

Excel ROWS Function

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

Excel - Excel Functions - Excel Formulas
Logo