Summary

The Excel ROWS function returns the count of rows in a given reference. For example, ROWS(A1:A3) returns 3, since the range A1:A3 contains 3 rows.

Purpose 

Get the number of rows in an array or reference.

Return value 

Number of rows

Syntax

=ROWS(array)
  • array - A reference to a cell or range of cells.

How to use 

The ROWS function returns the count of rows in a given reference as a number. For example, =ROWS(A1:A5) returns 5, since the range A1:A5 contains 5 rows. ROWS takes just one argument, called array, which can be a range or array.

Examples

Use the ROWS function to get the row count for a given reference or range. For example, there are 10 rows in the range A1:F10 so the formula below returns 10:

=ROWS(A1:F10) // returns 10

The range A1:Z100 contains 100 rows, so the formula below returns 100: 

=ROWS(A1:Z100) // returns 100

You can also use the ROWS function to get a row count for an array constant:

=ROWS({1;2;3;4;5}) // returns 5

Although there is no built-in function to count the number of cells in a range, you can use the ROWS function together with the COLUMNS function like this:

=COLUMNS(range)*ROWS(range) // total cells
=COLUMNS(A1:Z100)*ROWS(A1:Z100) // returns 2600

This article explains this formula in more detail.

Notes

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.