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)