Excel ROWS Function
How to use the ROWS Function (WS)
This Excel tutorial explains how to use the Excel ROWS function with syntax and examples.
SUMMARY:
The Excel ROWS function returns the count of rows in a given reference.
For example,
- ROWS(A1:C3) returns 3, since the range A1:C3 contains 3 rows.
PURPOSE:
To get the number of rows in an array or reference.
RETURN VALUE:
The ROWS function returns number of rows. It returns a numeric value.
SYNTAX:
=ROWS(array)
ARGUMENTS:
The ROWS function syntax has the following arguments:
- Array: Required. An array or array formula, or a reference to a range of cells for which you want the number of rows.
- A reference to a cell or range of cells.
- Use the ROWS function to get the row count for a given reference or range.
REMARKS:
You can also use the ROWS function to get a row count for an array constant:
- Array can be a range or a reference to a single contiguous group of cells.
- Array can be an array constant or an array created by another formula.
Diffrent way to use the Rows function...
