Table of Contents
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.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)