Total cells in a range

An excel formula to total cells in a range

Related Functions

Sponsored Link

 Total cells in a range
=ROWS(rng)*COLUMNS(rng)

If you need to count the total number of cells in a rectangular range, you can do so with the ROWS and COLUMNS functions. In the generic form of the formula (above) rng represents a range of cells.

In the example, the active cell contains this formula:

 
=ROWS(B4:C9)*COLUMNS(B4:C9)

How this formula works

There is no built-in function for counting the total numbers of cells in a range, so you need to use the ROWS and COLUMNS functions together. In the example, ROWS returns the total number of rows in rng, and COLUMNS returns the total number of columns in rng. The formula multiplies these values together and returns the result.

Note that this formula only works for a single rectangular range of cells.

Sponsored Link

0 votes. 0 / 5