How many row in Excel

Excel Row Count(Table of Contents)Introduction to Row Count in ExcelHow to Count the Rows in Excel?Introduction to Row Count in ExcelExcel provides a lot of built-in functions thro

How many row in Excel
Row count example

Excel Row Count(Table of Contents)

  • Introduction to Row Count in Excel
  • How to Count the Rows in Excel?

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.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Lets take some values in the excel sheet.

Row count example 1-1

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:

Row count example 1-2

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.

Row count example 6-1

ROWS() function gives you the count of rows in a range.

Row count example 6-2

How to Count the Rows in Excel?

Lets take some examples to understand the usage of ROWS functions.Popular Course in this category

Sale

Excel Training (21 Courses, 9+ Projects)21 Online Courses | 9 Hands-on Projects | 110+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.9 (10,617 ratings)Course Price

View Course


Related CoursesExcel Data Analysis Training (15 Courses, 8+ Projects)Excel for Finance Training (18 Courses, 7+ Projects)You can download this Row Count Excel Template here Row Count Excel Template

Example #1

We have given some employee data.

Row count example 1-3

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:

Row count example 1-4

Which returns you the number of rows containing the data in the supplied range.

The final result is given below:

Row count example 1-5

Example #2

We have given below some student marks subject-wise.

Row count example 2-1

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.

Row count example 2-2

The final result is given below:

Row count example 2-3

Example #3

We have given the below data values.

Example 3-1

We will pass the range of data values within the function for counting the number of rows.

Apply the function like the below screenshot:

Row count example 3-2

Press ENTER key here, and it will return the count of rows.

The final result is shown below:

Row count example 3-3

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:

Example 4-1

Now we will pass the range of the given dataset within the function like the below screenshot:

Row-count-example-4-2

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:

Row count example 4-3

Example #5

We have given some raw data.

Example 5-1

Some cell values are missing here, so now, for counting the rows, we will apply the function like the below screenshot:

Row-count-example-5-2

Hit the Enter key, and it will return the count of rows having data.

The final result is given below:

Row count example 5-3

Example #6

We have given a company employee data where some details are missing:

Example 6-1

Now apply the ROWS function to count the row containing data of employee:

Adding Months to Dates in Excel example 5-2

Hit the Enter key, and the final rows are:

Adding Months to Dates in Excel example 5-3

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 wont 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.

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

  1. COUNTA Function in Excel
  2. Count Function in Excel
  3. ROWS Function in Excel
  4. Add Rows in Excel Shortcut

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More0 SharesShareTweetShare

Video liên quan