Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

ROWS

Count of rows in a cell range in Excel
Returns the number of rows in a reference

Rational

Count of rows in a cell range.

Description

The Excel ROWS function returns the number of rows of a cell range or array formula. For example, =ROWS(E10:F100) returns 91 (91 rows in the cell range i.e. 10 to 100).

Syntax

=ROWS (array)

Parameters

array – A reference to a cell range

Return Value

An integer representing the total number of rows.

Key Notes

  • The ROWS function returns a count of rows in the specific range of cells, unlike ROW function that returns row number of the first cell in the reference.
  • The function accepts an array or array formula, or a reference to a range of cells.

Keep Reading Similar Functions:

Count all columns of a cell range in Excel

COLUMNS

The COLUMNS function returns a count of all columns of a cell range or array formula, =COLUMNS(E10:F100) returns 2 (two columns E & F).

Read More »
Find ROW number of a reference in Excel

ROW

The ROW function returns the row number of a reference cell. For example, =ROW(E9:E10) returns 9 (9th from top to bottom, only the first cell).

Read More »
Find number of areas in reference in Excel

AREAS

The AREAS function returns a number of areas or region. I.e., =AREAS((B2:C4,D8:F9)) returns 2 (number of areas), include extra sets of parentheses.

Read More »
Return address of a cell in Excel

ADDRESS

The ADDRESS function returns cell address from given row and column numbers of a worksheet. For example, if you pass ADDRESS(5,6) the function returns $F$5.

Read More »
Find column number for a reference in Excel

COLUMN

The COLUMN function returns the column number of a first reference cell. For example, =COLUMN(E10:F10) returns 5 (5th column, a sequence of E in alphabets).

Read More »