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.