< Go Back

Total cells in a range

To count the number of cells in a particularly rectangular range, one can use the COLUMNS function and the ROWS function.

There is not a direct function to count the total cells in a range; hence, one must combine both COLUMNS function and ROWS function together. As you know, multiply the numbers of rows with the number of columns will give us the total number of cells in that range.

Total Cells In A Range

Formula

=ROWS(rng)*COLUMNS(rng)

Argument

Rng is short for range and it represents the range of cells.

Explanation

Firstly, determine the range in which you want to count the cells.

Secondly, put the range in the function below:

=ROWS(rng)*COLUMNS(rng)

The return value is the total number of cells in that range.

Example

Figure 1. Example of how to count total cells in a range

 

Let’s take a look at the example in the photo above. The table range is B4:C10 that make the data range is B5:C10. Add the range to the generic formula like below:

=ROWS(B5:C10)*COLUMNS(B5:C10)

It returns the value of total cells in range B5:C10 which is 12.

Or you can calculate the number of columns and the number of rows in the range B5:C10 individually like in F5 and F6:

=COLUMNS(B5:C10)

=ROWS(B5:C10)

Then multiply those cell references together and you should get the same result.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar