ROWS
Syntax:
ROWS ( array )
Description: Finds the number of rows corresponding to array.
Arguments:
Name |
Type |
Description |
|---|---|---|
array |
array, reference to a single cell, or a reference to a range of contiguous cells |
A set of rows. |
Return Type and Value: number – The number of rows corresponding to array.
However, if the range of cells referred to by array is not contiguous, #NULL! is returned.
example: