## Total cells in a range

Written by kazamraza
no comments

Classified in : Excel Formulas

In some cases we need to calculate total number of cells in a range. The COUNT,COUNTA and COUNTBLANK Functions are different in nature.

We use ROWS formula to calculate total number of cells in a range.

For example we want to calculate total number of cells in range B5:B23, we can use formula:

```
=ROWS(B5:B23)
```