Excel ROWS Function

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

  1. Click on an empty cell (like F5 ).
an empty cell in excel

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

 fx icon in excel

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

insert function tab in excel

4. Select Lookup & reference category.

5. Select ROWS function.

6. Then select ok.

excel ROWS function.

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.

How to use ROWS function in excel

Examples of ROWS function in excel

Examples of ROWS function in excel

ROWS related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *