How to count total number of cells in a rectangular range in Excel

by

If you need to count the total number of cells in a rectangular range, you can do so with the ROWS and COLUMNS functions.

Formula

=ROWS(range)*COLUMNS(range)

Worked Example:   How to return TRUE when all cells in range are blank in Excel

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

Explanation

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 range, and COLUMNS returns the total number of columns in range. The formula multiplies these values together and returns the result.

Worked Example:   Extract multiple matches into separate columns in Excel
Worked Example:   How to create dynamic named range with OFFSET in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *