# How to use Excel ROWS Function

This Excel tutorial explains how to use the **ROWS function** with syntax and examples.

## Excel ROWS Function Description

The Microsoft Excel ROWS function returns the number of rows in a cell reference.

The ROWS function is a built-in function in Excel that is categorized as a *Lookup/Reference Function*. The ROWS function can be entered as part of a formula in a cell of a worksheet.

**Explanation: **The Excel ROWS function returns the count of rows in a given reference. For example, ROWS(A1:A3) returns 3, since the range A1:A3 contains 3 columns.

## Syntax

The syntax for the ROWS function in Microsoft Excel is:

ROWS ( reference )

### Arguments

- reference
- A reference to a range of cells or an array.

## Returns

The ROWS function returns a numeric value.