ROWS
Returns the number of rows in a reference.
Lookup & ReferenceLookup & Matching Essentials
What it does
Counts rows in a range.
Syntax
ROWS(array)
Arguments
array(range) — Range.
Examples
Count Rows
Rows in A1:A10.
FORMULA
=ROWS(A1:A10)
RESULT
10
SAMPLE DATA
| A | |
|---|---|
| 1 | Range |
| 2 | (Data) |