How To Use Excel ROWS Function

how to use excel rows function

Quick Intro

Use Excel ROW Function to get the number of rows in an array or reference. In simple words, it will return the number of rows included in a reference.

For example, If you refer to a range A1:B4, it will return 4 in the result.

Syntax

ROWS(array)

  • array A cell reference or an array to check a number of rows.

More Information on Excel ROWS Function

  • You can also use named range in rows function.
  • Rows function is not concerned with the values in the cells, it will simply return the number of rows in a reference.

Examples

In the below example, I have used reference A1:A10 which has 10 rows in it and ROWS function has returned 10 in the result.

Return Rows In A Range With Excel ROWS Function

You can also use rows function to create a list of serial numbers. In the below example, I have used the starting cell of the reference as an absolute reference.

Serial Numbers With Excel ROWS Function

So, when I drag the formula down it will create a list of serial numbers.

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel ROWS Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have ROW function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.