In this post we will see how we could count total number of cells in name range or any selected range in excel.
We could either take the actual selection in the format A2:F4 or could use a name range like Range1 etc.
We will count the number of cells in a selection by using ROWS() and COLUMNS() formula in excel.
ROWS(range) formula returns number of rows that are involved in the range, selected range could be a name range or a simple range.
COLUMNS(range) formula returns number of columns that are involved in the range, selected range could be a name range or a simple range.
Below is an example demonstrating how we could count the total number of cells used in a range.
As you could see below I have selected a name range “Range1” and would like to calculate how many cells are there in the selected range.
To count number of cells in a range, enter the formula =ROWS(Range1)*COLUMNS(Range1) in a cell as shown below in the pic
Alternatively you could have entered ROWS(A1:C6)*COLUMNS(A1:C6) ,if you worked on a simple range.
This formula will give us total number of cells in a range as we are multiplying number of rows with number of columns involved in a range.
Hope this helped.