ROWS Function in Excel: How Many Rows in a Range

📎 This article includes 1 downloadable practice file ↓

LookupLevel: IntermediateAvailable in: Excel 2007+

In this article

1. Syntax
2. Examples
3. Example 1
4. Example 2
5. ROWS in practice
6. Where you will use it
7. Worked example
8. Mistakes people make
9. Related functions
10. Continue learning

ROWS counts the rows in a range or array — the classic helper for top-N lists that fill down.

Syntax

=ROWS(array)

Argument	What it means
array	Range or array.

Examples

Example 1

=LARGE($E$2:$E$500, ROWS(E$2:E2))

Fill down: 1st, 2nd, 3rd… largest.

Example 2

=ROWS(FILTER(A2:A500, B2:B500="North"))

Count of filtered results (Excel 365).

ROWS in practice

Where you will use it

• Count rows in a range or table
• Running serial numbers: ROWS($A$2:A2)
• Check expected record counts

Worked example

Range	Formula	Result
A2:A10	=ROWS(INDIRECT(A2))	9
B1:B500	=ROWS(INDIRECT(A3))	500
5:9	=ROWS(INDIRECT(A4))	5

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
Confusing with ROW	ROWS counts, ROW gives the position
Counting data rows	Use COUNTA for filled rows

Related functions

ROW · COLUMNS · COUNTA

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Continue learning

All Lookup & Reference guides →

Excel #N/A Error in VLOOKUP and XLOOKUP: 5 Fixes That Actually WorkThe #N/A ('Value Not Available') error in Microsoft Excel signals that a lookup function—such…TOROW Function in Excel: Flatten Into One RowTOROW flattens a block into a single row, optionally skipping blanks and errors.WRAPCOLS Function in Excel: Fold a List Into ColumnsWRAPCOLS takes a long list and wraps it into columns of a fixed height…WRAPROWS Function in Excel: Reshape a List Into a GridWRAPROWS reshapes a single column into rows of a fixed width — e.g. a…

📎 Practice files for this article

• 📗
  Practice workbook: Lookup & reference17 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 35 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.