# ROWS

## Content

This function returns the number of rows in an array.

## Syntax

`ROWS(array)`

## Arguments

The argument is an array, an array formula, or a range of cells.

## Data Types

Accepts array. Returns numeric data.

## Examples

`ROWS(B2:B14)` gives the result 13

`ROWS(R2C6:R4C12)` gives the result 3

`ROWS($H$2:$H$8)` gives the result 7

`ROWS(R[2]C[3]:R[8]C[3])` gives the result 7

`ROWS(R3C2:R17C2)` gives the result 15