Excel ROWS Function

HomeExcel FunctionsExcel ROWS Function (Example + Sample File)

What is EXCEL ROWS FUNCTION

The Excel ROWS Function is listed under Microsoft Excel's Lookup Functions category. It returns a count of the rows from the referred range. In simple words, with ROWS function you can count how many rows are in the range you have referred.

How to use it

To learn how to use the ROWS function in Excel, you need to understand its syntax and arguments:

Syntax

ROWS(array)

Arguments

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

Notes

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

Example

To master the ROWS function we need to try it out in an example and below is one which you can try out:

In the below example, we have referred to a vertical range of 10 cells and it has returned 10 in the result as the range includes 10 rows.

excel rows function example

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.