Introduction
Excel ROWS Function can be used when you want to get the number of rows in a specified range or array. It returns a number that represents the total number of rows in the specified range or array.
When to use Excel ROWS Function
Excel ROWS Function can be used when you want to get the number of rows in a specified range or array.
What it Returns
It returns a number that represents the total number of rows in the specified range or array.
Syntax
=ROWS(array)
Input Arguments
- array – it could be an array, an array formula or a reference to a contiguous range of cells.