Article updated on May 02, 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.