For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Lookup and reference

ROWS Function

Returns the number of rows in a reference


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Syntax

ROWS(array)

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

Applies To

Excel 2003 and above

Examples

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Examples for Excel's ROWS function.

Other Help

 

Charley's SwipeFile charts


Free Excel Dashboards