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.
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 […]