ROWS Function

About

ROWS function in Excel returns the number of rows in a reference.

Function Type

Lookup and reference

Purpose

Get the count of rows in a reference

Return value

Number of rows

Syntax

=ROWS(array)

Arguments

array – a cell reference or a range reference.


Example


Notes

ROWS function doesn’t accept multiple references.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel