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.
- Enter the “ROWS” function in a cell.
- Type the starting parentheses.
- Refer to the range of the cells.
- Type the closing parentheses.
- Hit enter to get the result.
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.
=COUNTA(A1:A10)When you hit enter after referring to the range, it returns 5, the total number of rows in the data.
Read Also – How to Count Colored Cells in Excel (Using a Formula)
Count Rows with Blank Cells
In the same way, you can also count the rows with blank cells, which are cells without data.
Once you hit enter, it returns 5, the exact number of rows with blank cells.
Count Rows with Numbers
The COUNT function needs to be used to count the rows with the 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.
- Make sure to check out this amazing list of formulas to count cells.