Count Rows in Excel (All, Blank, Non-Blank, & with Numbers)

puneet-gogia-excel-champs

- Written by Puneet

There are multiple ways to count rows in Excel. But if you want to count the rows irrespective of whether data is in the cells, you can use the ROWS function.

count-rows
  1. Enter the “ROWS” function in a cell.
  2. Type the starting parentheses.
  3. Refer to the range of the cells.
  4. Type the closing parentheses.
  5. Hit enter to get the result.
rows-function-to-count-rows

Count the Rows with the Non-Blank Cell

And if you want to count the rows for the cells with a value, you can use the count function.

count-rows-with-non-blank-cells
=COUNTA(A1:A10)

When you hit enter after referring to the range, it returns 5, the total number of rows in the data.

counta-to-count-non-blank-rows

Count Rows with Blank Cells

In the same way, you can also count the rows with the cell that have no data, which means the blank cells.

count-rows-with-blank-cells

Once you hit enter, it returns 5, the exact number of rows with blank cells.

rows-with-blank-cells

Count Rows with Numbers

The COUNT function needs to use to count the rows with the numbers.

count-rows-with-numbers

The moment you hit enter, it returns 3 in the result. So as you can see, we have 5 blank cells and 5 non-blank rows. But in the non-blank rows (with value), we have only three cells with the numbers, and that’s why the result is 3.

rows-with-numbers-only

Get the Excel File

Last Updated: June 14, 2024