ROWS Function Examples – Excel & Google Sheets

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.

AutoMacro - VBA Code Generator

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

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!