Rows() Function

The Excel ROWS function returns the count of rows in a given reference. For example, ROWS(A1:A3) returns 3, since the range A1:A3 contains 3 columns.

Syntax

The syntax for the ROWS function in Microsoft Excel is:

=ROWS ( reference )

reference

A reference to a range of cells or an array.

Rows Function Examples

The following spreadsheet shows three simple examples of the Excel Rows function.

Formulas:

	A
1	=ROWS( B1 )
2	=ROWS( B1:E5 )
3	=ROWS( B:B )

Results:

A 1 1 2 5 3 1048576

                Note that the above functions were calculated in Excel 2010. Therefore, the formula in cell A3 (which returns the number of rows in the whole of column B of the spreadsheet) returns the value 1,048,576, as this is the number of rows in Excel 2010. If this example were run in Excel 2003, it would return the number 65,536.

Reference:

https://exceljet.net/excel-functions/excel-rows-function

https://www.techonthenet.com/excel/formulas/rows.php

http://www.excelfunctions.net/Excel-Rows-Function.html

follow us on http://arivilm.blogspot.in

like us on https://www.facebook.com/Arivilm2501/