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:

ROWS(E16:H16) results in 1
ROWS(E16:G18) results in 3
ROWS({1,2;3,4}) results in 2

end example]