Excel Row Count (Table of Contents)
Row Count in Excel
Excel provides a lot of built-in functions through which we can do multiple calculations. We can also count the rows and columns in excel. Here in this article, we will discuss the Row Count in Excel. If we want to count the rows which contain data, select all the cells of the first column by clicking on the Column header. It will display the row count on the status bar in the lower right corner.
Let’s take some values in the excel sheet.
Select the entire column which contains data. Now click on the column label for counting the rows, it will show you the row count. Refer below screenshot:
There are 2 functions which can be used for counting the rows.
- ROW()
- ROWS()
ROW() function gives you the row number of a particular cell.
ROWS() function gives you the count of rows in a range.
How to Count the Rows in Excel?
Let’s take some examples to understand the usage of ROWS functions.
Row Count in Excel – Example #1
We have given some employee data.
For counting the rows here, we will use the below function here:
=ROWS(range)
Where range = a range of cells containing data.
Now we will apply the above function like below screenshot:
Which returns you the number of rows containing the data in the supplied range.
The final result is given below:
Row Count in Excel – Example #2
We have given below some student marks subject wise.
As we can see in the above dataset, some details are missing.
Now for counting the rows which contain data, we will apply the ROWS function here as per below screenshot.
The final result is given below:
Row Count in Excel – Example #3
We have given below data values.
Now for counting the number of rows, we will pass the range of data values within the function.
Apply the function like below screenshot:
Press ENTER key here and it will return the count of rows.
The final result is shown below:
Explanation:
When we pass the range of cells, it gives you the count of cells that you selected.
Row Count in Excel – Example #4
We have given below product details:
Now we will pass the range of given dataset within the function like below screenshot:
Press ENTER key and it will give you the count of rows which contains data in the passed range.
The final result is given below:
Row Count in Excel – Example #5
We have given some raw data.
Some cell values are missing here, so now for counting the rows we will apply the function like below screenshot:
Hit the Enter key and it will return the count of rows having data.
The final result is given below:
Row Count in Excel – Example #6
We have given a company employee data where some details are missing:
Now apply the ROWS function to count the row containing data of employee:
Hit the Enter key and the final rows are:
Things to Remember About Row Count in Excel
- If you click on the column heading for counting the rows, it will give you the count which contains data.
- If you pass a range of cells, it will return you the number of cells that you have selected.
- If the column contains only the data only in one cell, the status bar won’t show you anything. That is, the status bar stays blank.
- If the data are given in the table form then for counting the rows, you can pass the table range within the ROWS function.
- You also can do the setting of the message appearing in the status bar. For this, do a right click on the status bar and click the item which you want to see or remove.
Recommended Articles
This has been a guide to Row Count in Excel. Here we discussed How to Count the Rows along with practical examples and downloadable excel template. You can also go through our other suggested articles–
