# How To Use Excel ROWS Function

How To Use Excel ROWS Function2016-04-29T10:19:51+00:00

## 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.

• 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.

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.

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

## 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.