August 2, 2021

# ROWS function in Excel

In this lesson we will learn how the ROWS function works in Excel. We use ROWS function to count the number of rows in a table.

`=ROWS(table)`
• Table : We need to provide the table as an argument for which the number of rows need to be counted

In below example we have used the below formula in cell E10 to count the number of rows in table A9:C16.

`=ROWS(A9:C16)` ##### Note :
• You might be thinking that getting the number of rows in a table is easy. Without using the ROWS function it can be done by just selecting the first cell to last cell of a single column of the table and number of rows will be displayed in the status bar. But remember that feature won’t consider the blank cells. That will actually count the number of non-blank cells only.
• But using ROWS function, the actual number of rows in the specified table can be retrieved even if there is one or all blank cells present in any row(as in our example).
• The ROWS function can be useful in the scenario where the table doesn’t start from the first row of the Excel (as in our example) and we need to get the number of rows as part of any formula with the table.

You can also check here to understand how the ROWS function works in Google Sheet.

You can also check to understand here how the COLUMNS function works in Excel.

You can also check here to understand how the COLUMNS function works in Google Sheet.

You can also check here to understand how the COLUMN function works in Excel.

You can also check here to understand how the COLUMN function works in Google Sheet.

You can also check here to understand how the ROW function works in Excel.

You can also check here to understand how the ROW function works in Google Sheet. #### abhraisraja

View all posts by abhraisraja →