Return to List of Excel Functions

ROWS Function Examples – Excel & Google Sheets

Download Example Workbook

Download the example workbook

This Tutorial demonstrates how to use the Excel ROWS Function in Excel to count the number of rows.

ROWS Main Function

ROWS Function Description:

The ROWS Function Returns the number of rows in an array.

To use the ROWS Excel Worksheet Function, select a cell and type:

rows formula syntax

(Notice how the formula inputs appear)

ROW Function Syntax and Inputs:

=ROWS(array)

array – Count the number of rows in this array.

Additional Notes

Use the ROWS Function to calculate the number of columns in a range of cells.

Return to the List of all Functions in Excel

 

ROWS Function 

The ROWS Function returns the number of rows in a given cell reference.

=ROW(B4)

ROWS EX 01

ROWS Function – Cell Range

You can also enter a cell range and it will return the total number of rows in it.

=ROWS(B5:U7)

ROWS EX 02

ROWS Function – Array Constant

You can also count the number of rows in a given array constant.

=ROWS({1,2,3;4,5,6;7,8,9})

ROWS EX 03

ROWS Function in Google Sheets

The ROWS Function works exactly the same in Google Sheets as in Excel:

ROWS Google Function