How to use ROWS Function in Excel

In simple words “ROWS” function in excel returns the count of the number of rows selected in the range. It is different from the row function, where row function gave us the row number for the selected cell instead rows function takes an array of rows as an argument and gives us the number of rows in that array, this is also a referencing function to identify the number of rows in a given array.

Syntax:= ROWS (array)

The ROWS function syntax has the following arguments:

  • Required. An array, an array formula, or a reference to a range of cells for which you want the number of rows.

Example: Let’s look at some Excel ROWS function examples and explore how to use the ROWS function as a worksheet function in Microsoft Excel:

Syntax:  =ROWS(A8)

Result:

ROWS Function in Excel - How to use ROWS Function in Excel

Based on the Excel spreadsheet above, the following ROWS examples would return:

Syntax: =ROWS(A8:A9)
Result: 2

Syntax: =ROWS(D4:G11)
Result: 8

Syntax: =ROWS(B11:C12)
Result: 2

Syntax: =ROWS(A11:C14)
Result: 4

Syntax: =ROWS(D14:D21)
Result: 8

Syntax: =ROWS(D1:D9)
Result: 9

Syntax: =ROWS({1,2,3,4,5;6,7,8,9,10;11,12,13,14,15})
Result: 3

Note:

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

Add a Comment

Your email address will not be published. Required fields are marked *