ROWS and COLUMNS functions. Get the number of rows and columns in a cell range.
Function to get the number of rows and columns in a range of cells specified in the argument.
The ROW and COLUMN functions are similar in name to the ROWS and COLUMN functions, but that one gets the location of the specified cell.
ROWS and COLUMNS functions get the size of columns and rows in a specified range.
How it works
=ROWS(array)
=COLUMNS(array)
| Name | Omission | Explanation |
|---|---|---|
| array | Required argument. Cell range to get the number of rows and columns. |
Demonstrate
Specify a cell range as an argument. A cell range name is also acceptable.
However, specifying multiple cell ranges will result in a #REF!.
---