Cellgrids Cellgrids
Home › Excel formulas › Lookup and Reference › ROWS

ROWS Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

ROWS is an Excel Lookup & Reference function. Counts how many rows are in a range.

ROWS syntax

=ROWS(array)

Arguments

When to use ROWS

ROWS is used to pull matching data from one part of a workbook into another.

Practice ROWS online, free

Open the live Excel-style spreadsheet and try ROWS yourself. No Excel install or sign-up needed to start.

Practice ROWS now →

More Lookup & Reference functions

Frequently asked questions

What does the ROWS function do in Excel?

Counts how many rows are in a range.

What is the syntax of ROWS in Excel?

The syntax is =ROWS(array). array: The range or array to evaluate.

Where can I practice ROWS online for free?

Open the free live spreadsheet on Cellgrids and try ROWS yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts