This post will guide you how to use Google Sheets **ROWS **function with syntax and examples.

**Description**

The Google Sheets ROWS function counts the number of rows in a cell reference.

The ROWS function can be used to return the number of rows in a specified range in google sheets. The purpose of this function is to get the number of rows in an array or cell reference and It’s returned value is a number of rows.

The ROWS function is a build-in function in Google Sheets and it is categorized as a LOOKUP function**.**

**Syntax**

The syntax of the ROWS function is as below:

**= ROWS(array)**

**Where** the ROWS function arguments is:

**array**-This is an required argument. An array, or A reference to a range of cells.

**Note:**

- ROWS just takes one argument, it can be a range or a array.
- Array can be a range or a cell reference
- If you want to count columns, you can use the COLUMNS function.
- If you want to get row numbers, you can use the ROW function.

## Google Sheets ROWS Function Examples

The below examples will show you how to use google sheets ROWS Function to return the number of rows in a range of cells.

**#1** To get the number of rows in the cell range “**A1:C4**”, just using the following ROWS formula:

=ROWS(A1:C4)