Total cells in a range

Total cells in a range

Related Functions


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:


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.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas