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: