If you need to count the total number of cells in a rectangular range, you can do so with the ROWS and COLUMNS functions.
Note that this formula only works for a single rectangular 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 range, and COLUMNS returns the total number of columns in range. The formula multiplies these values together and returns the result.