Excel Function : ROWS

Download now!

Excel Function : ROWS

Category

Lookup and reference

Description

Returns the number of rows in a reference

Microsoft Excel Reference Page

https://support.office.com/en-us/article/ROWS-function-b592593e-3fc2-47f2-bec1-bda493811597

Syntax and Description of the ROWS Excel Function

The syntax for the ROWS function in Microsoft Excel is: =ROWS(array) Where "array" is the range of cells or array that you want to count the number of rows in.

About ROWS Excel Function

ROWS(array) returns the number of rows in an array.