What is ROWS Function in Excel?
The ROWS function is one of the Lookup & reference functions of Excel.
It Returns the number of rows in a reference or array.
We can find this function in Lookup & reference of insert function Tab.
How to use ROWS function in excel
- Click on an empty cell (like F5 ).

2. Click on the fx icon (or press shift+F3).

3. In the insert function tab you will see all functions.

4. Select Lookup & reference category.
5. Select ROWS function.
6. Then select ok.

7. In the function arguments Tab, you will see ROWS function.
8. Array section is an array, an array formula, or a reference to a range of cells for which you want the number of rows.
9. You will see the result in the formula result section.

Examples of ROWS function in excel

ROWS related functions
- ROW function
- COLUMN function
- COLUMNS function
- SMALL function