Excel Row Count (Table of Contents)
Introduction to 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 to the below screenshot:
There are 2 functions that 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.
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 the below screenshot:
Which returns you the number of rows containing the data in the supplied range.
The final result is given below:
Example #2
We have given below some student marks subject-wise.
As we can see in the above dataset, some details are missing.
We will apply the ROWS function here as per the below screenshot for counting the rows containing data.
The final result is given below:
Example #3
We have given the below data values.
We will pass the range of data values within the function for counting the number of rows.
Apply the function like the 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.
Example #4
We have given below product details:
Now we will pass the range of the given dataset within the function like the below screenshot:
Press ENTER key, and it will give you the count of rows that contain data in the passing range.
The final result is given below:
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 the below screenshot:
Hit the Enter key, and it will return the count of rows having data.
The final result is given below:
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. Do a right-click on the status bar and click the item 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 a downloadable excel template. You can also go through our other suggested articles–
23 Online Courses | 9 Hands-on Projects | 110+ Hours | Verifiable Certificate of Completion
4.9
View Course
Related Courses