How does ROWS Function in Excel works : Tutorial How-To Guide

The ROWS function in Microsoft® Excel takes an Excel range and returns the number of rows that are contained within the range. Follow the steps given in this video to use the ROWS Function in Microsoft® Excel.

ROWS function
Returns the number of rows in a reference or array.

Syntax
ROWS(array)

The ROWS function syntax has the following argument:

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

Example
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

Formula

=ROWS(C1:E4)

=ROWS({1,2,3;4,5,6})

Go to the webpage https://support.office.com/en-au/arti... to know about the complete details i.e. Syntax and Remarks of this Microsoft® Excel function.


Content in this video is provided on an "as is" basis with no express or implied warranties whatsoever. Any reference of any third party logos, brand names, trademarks, services marks, trade names, trade dress and copyrights shall not imply any affiliation to such third parties, unless expressly specified

How does ROWS Function in Excel works : Tutorial
0 Likes	0 Dislikes
22 views views	50,888 followers
Science & Technology	Upload TimePublished on 29 Sep 2015