ROWS Function

The Excel ROWS function returns the count of rows in a given reference. For example, ROWS(A1:A3) returns 3, since the range A1:A3 contains 3 rows.

April 14, 2025 · 1 min · 116 words · David Sullivan

Table of Contents

ROWS takes just one argument, calledarray, which can be arangeorarray.

Examples

Use the ROWS function to get the row count for a given reference or range.

For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet.

Excel formula: Random sort

When no reference is provided, ROW returns the row number of the cell which contains the formula.

COLUMN Function

The Excel COLUMN function returns the column number for a reference.

For example, COLUMN(C5) returns 3, since C is the third column in the spreadsheet.

Excel formula: Get relative row numbers in range

When no reference is provided, COLUMN returns the column number of the cell which contains the formula.

COLUMNS Function

The Excel COLUMNS function returns the count of columns in a given reference.

Excel formula: Last row number in range

Excel formula: Total rows in range

Excel formula: Get address of named range or table

Excel formula: Count table rows

Excel formula: Randomly assign data to groups

Excel formula: First column number in range

Excel formula: Dynamic date list

Excel formula: Average last N values in a table

Excel formula: Address of last cell in range

Excel formula: Random value from list or table

Excel formula: Combine ranges

Excel formula: Multiple matches into separate rows

Excel formula: Count cells in range

Excel ROW function

Excel COLUMN function

Excel COLUMNS function