ROWS

Counts rows in the specified range or array, returning an integer value. If the input is empty, the function returns 0.

Parameter List

Syntax
ROWS(array)
array

A range, array, or reference whose rows will be counted. For example: A1:A10.

Examples

ROWS(A1:A10) returns 10