Related Topics:
	Function Wizard Functions

ROWS

Description: Based on a reference or array, returns the number of rows.

Syntax: ROWS(Array)

• Array is an array, an array formula or a reference to a range of cells for which you want the number of rows.

Example:

• ROWS(A1:C4) = 4

• ROWS({1, 2, 3; 4, 5, 6}) = 2