ROWS and COLUMNS functions. Get the number of rows and columns in a cell range.

06/06/2023

Japanese version.

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)
NameOmissionExplanation
arrayRequired 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!.

---

Links

Microsoft Excel Functions Lookup & Reference