How to use the ROWS function
Article updated on January 25, 2018
The ROWS function allows you to calculate the number of rows in a cell range.
The example above shows that cell range B3:B10 contains 8 rows.
Excel Function Syntax
ROWS(array)
Arguments
| array | Required. A cell range for which you want to calculate the number of rows. |
Comments
The ROWS function also calculates the number of rows in an array.
=ROWS({1,2,3;4,5,6;2,3,4}) returns 3.
The array has three rows. The ; (semicolon) character is a row delimiting character in an array.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas.
Click on headers to sort table.
Articles with the 'ROWS' Function
The following 3 articles have formulas that contain the ROWS function.
This post explains how to lookup a value and return multiple values. No array formula required.
Here comes another post about the MMULT function, today I made a dynamic scoreboard. There are five women competing and there […]
Rearrange cells in a cell range to vertically distributed values
The formula in cell B8 uses a named range to calculate the row and column needed to extract the correct […]Functions in 'Lookup and reference'
The ROWS function function is one of many functions in the 'Lookup and reference' category.
The ADDRESS function returns the address of a specific cell, you need to provide a row and column number. Formula […]
The AREAS function returns the number of cell ranges and single cells in a reference. Formula in cell B3: =AREAS(E3:E4) […]
The CHOOSE function allows you to retrieve a value based on a number, cell range C3:C4 in the picture above […]
The COLUMN function returns the column number of the top left cell of a cell reference. If the argument is not […]
The COLUMNS function allows you to calculate the number of columns in a cell range. The example above shows that cell […]
The FORMULATEXT function returns a formula as a text string. Formula in cell C3: =FORMULATEXT(B3) Excel Function Syntax FORMULATEXT(reference) Arguments […]
The HLOOKUP function lets you search the top row in a data range for a value and return another value […]
The HYPERLINK function allows you to build a link in a cell pointing to something else like a file, workbook, cell, […]
Gets a value in a specific cell range based on a row and column number.
The INDIRECT function returns the cell reference based on a text string and shows the content of that cell reference. […]
Finds a value in a sorted cell range and returns a value on the same row.
Identify the position of a value in an array.
In this post I am going to provide some basic examples to demonstrate how the OFFSET function works. I also […]
The ROW function calculates the row number of a cell reference. Excel Function Syntax ROW(reference) Arguments reference Optional. A reference […]
The ROWS function allows you to calculate the number of rows in a cell range. The example above shows that cell […]
The transpose function allows you to convert a vertical range to a horizontal range, or vice versa. A vertical range […]
The VLOOKUP function lets you search the leftmost column for a value and return another value on the same row […]
