Functions
ROWS
Returns the number of rows in an array or range
Try it
When to use it
When should I use ROWS?
Use ROWS to count the number of rows in an array or range, often used in dynamic formulas to adapt to variable-height data.
Used in
Syntax
ROWS(array)