ROWS Function Examples – Excel & Google Sheets
Written by
Reviewed by
Last updated on November 6, 2023
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 Function
The ROWS Function returns the number of rows in a given cell reference.
=ROW(B4)
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 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 Function in Google Sheets
The ROWS Function works exactly the same in Google Sheets as in Excel:
