## Purpose

## Return value

## Syntax

`=ROWS(array)`

*array*- A reference to a cell or range of cells.

## How to use

The ROWS function returns the count of rows in a given reference as a number. For example, =ROWS(A1:A5) returns 5, since the range A1:A5 contains 5 rows. ROWS takes just one argument, called *array*, which can be a range or array.

### Examples

Use the ROWS function to get the row count for a given reference or range. For example, there are 10 rows in the range A1:F10 so the formula below returns 10:

```
=ROWS(A1:F10) // returns 10
```

The range A1:Z100 contains 100 rows, so the formula below returns 100:

```
=ROWS(A1:Z100) // returns 100
```

You can also use the ROWS function to get a row count for an array constant:

```
=ROWS({1;2;3;4;5}) // returns 5
```

Although there is no built-in function to count the number of cells in a range, you can use the ROWS function together with the COLUMNS function like this:

```
=COLUMNS(range)*ROWS(range) // total cells
=COLUMNS(A1:Z100)*ROWS(A1:Z100) // returns 2600
```

This article explains this formula in more detail.

### Notes

*Array*can be a range or a reference to a single contiguous group of cells.*Array*can be an array constant or an array created by another formula.- To count
*columns*, see the COLUMNS function. - To get row
*numbers*, see the ROW function. - To
*lookup*a row number, see the MATCH function.

## ROWS function examples

### Address of last cell in range

### Random sort

### Random value from list or table

### Get address of named range or table

### Count table rows

### First column number in range

### Multiple matches into separate rows

### Count cells in range

### Last n rows

### Dynamic date list

### Display sorted values with helper column

### Combine ranges

### Get relative row numbers in range

### Total rows in range

### Last row number in range

## ROWS function videos

### How to remove an Excel Table

### Formulas to query a table

### How to perform a random sort

### How to create a named range

### Introduction to structured references

### What is a dynamic named range

### How Excel Table ranges work

### How to create a dynamic named range with a Table

### How to count items in a filtered list

## Related functions

### ROW Function

The Excel ROW function returns the row number for a reference. For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet. When no reference is provided, ROW returns the row number of the cell which contains the formula.

### COLUMN Function

The Excel COLUMN function returns the column number for a reference. For example, COLUMN(C5) returns 3, since C is the third column in the spreadsheet. When no reference is provided, COLUMN returns the column number of the cell which contains the formula.

### COLUMNS Function

The Excel COLUMNS function returns the count of columns in a given reference. For example, COLUMNS(A1:C3) returns 3, since the range A1:C3 contains 3 columns.