Free Online Tutorials on Spreadsheets

Excel ROWS function

ROWS function returns the number of rows against a reference or array. For example, =ROWS(E5:E8) returns 4, because there 4 rows in the range.

Syntax

ROWS(array)

The function has the following argument:

array – Required. a reference, an array or range of cells for which number of rows needed.

Example

For more detail, visit Microsoft Office website.

Related Functions

ROW function returns the row number for a reference. For example, =ROW(B2) returns ‘2’ because B2 is the second row in the spreadsheet.

COLUMN function returns the column number against the given cell reference.

COLUMNS function uses to find out the number of columns in a selected array or reference.




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved