Learn Excel - Simplify Life with Excel Concepts

Excel ROWS Function

ROWS Function

How to use the ROWS Function (WS)

This Excel tutorial explains how to use the Excel ROWS function with syntax and examples.


The Excel ROWS function returns the count of rows in a given reference.

For example,

  • ROWS(A1:C3) returns 3, since the range A1:C3 contains 3 rows.


To get the number of rows in an array or reference.


The ROWS function returns number of rows. It returns a numeric value.




The ROWS function syntax has the following arguments:

  • Array: Required. An array or array formula, or a reference to a range of cells for which you want the number of rows.
    • A reference to a cell or range of cells.
    • Use the ROWS function to get the row count for a given reference or range.


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

  • Array can be a range or a reference to a single contiguous group of cells.
  • Array can be an array constant or an array created by another formula.

Useful Links: Link 1Link 2Link 3Link 4