Tip Printed from ExcelTip.com

---

Count the number of cells in a range in Microsoft Excel


Assume Range A1:B15

Use the following function to count the number of cells in the range
=ROWS(A1:B15)*COLUMNS(A1:B15)

The result: 30