Total cells in a range

Written by kazamraza no comments
Classified in : Excel Formulas Tags : none

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)

.