How To Calculate Total cells in a range in Excel Office 365?
Tags: excelformula, excelformulas
Published: 2021-10-26 07:53:43

---
title: How To Calculate Total cells in a range in Excel Office 365?
published: true
date: 2021-10-25 10:47:48 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/how-to-calculate-total-cells-in-a-range-in-excel-office-365/
---

So far we have learned the formulas to **[total characters in a range](https://geekexcel.com/excel-formulas-to-count-total-characters-in-a-range/)**, **[total words in a cell](https://geekexcel.com/excel-formulas-to-count-total-words-in-a-cell/)**. Similarly, here we will discuss the formulas to  **calculate total cells in a range** in Excel Office 365. Utilize the below-mentioned formula!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Generic Formula

- If you want to calculate total cells in a range, you can use the below **formula**.

```
=[ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(rng)*[COLUMNS](https://geekexcel.com/steps-to-use-columns-function-in-microsoft-excel-365-simple-way/)(rng)

```

## Syntax Explanation

- **ROWS** – This function will return the count of rows in a given reference. Read more on the [**ROWS function**](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/).
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **rng**  – It represents the input range.
- **Multiplication (\*)** – In this symbol will multiply any two values or numbers.
- **COLUMNS**  – The **[COLUMNS function](https://geekexcel.com/steps-to-use-columns-function-in-microsoft-excel-365-simple-way/)** helps to return the count of columns in a given reference.

## Practical Example

- Firstly, you have to **create a sample data** in Microsoft Excel.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Sample-data-47.png)<figcaption>Sample data</figcaption>

- Then, to count the total number of cells in a rectangular range, you need to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(B5:C10)*[COLUMNS](https://geekexcel.com/steps-to-use-columns-function-in-microsoft-excel-365-simple-way/)(B5:C10)

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Use-the-Formula-6.png)<figcaption>Use the Formula for Rows</figcaption>

- Now, you will get the result for the **range B5:C10**  **in rows** as given below.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Result-for-Row.png)<figcaption>Result for Rows</figcaption>

- After that, to calculate total range in **column** , you have to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(B5:C10)*[COLUMNS](https://geekexcel.com/steps-to-use-columns-function-in-microsoft-excel-365-simple-way/)(B5:C10)

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Use-the-formula-for-columns.png)<figcaption>Use the Formula for Columns</figcaption>

- You will get the result for the **range B5:C10**  **in columns** as given below.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Result-for-columns.png)<figcaption>Result for Columns</figcaption>

- Now, to calculate total range in **cells** , you have to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(B5:C10)*[COLUMNS](https://geekexcel.com/steps-to-use-columns-function-in-microsoft-excel-365-simple-way/)(B5:C10)

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Use-the-formula-for-cells.png)<figcaption>Use the Formula for Cells</figcaption>

- Finally, you will get the result for the **range B5:C10 in cells** as given below.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Result-for-cells.png)<figcaption>Result for Cells</figcaption>

## Wrap-Up

From this tutorial, we described the formulas to **calculate total cells in a range** in Excel Office 365. Hope that this article is useful to you. If you have any  **doubts/queries,**  feel free to share them with us. Thank you so much for Reading!! Keep learning on **[Geek Excel](https://geekexcel.com/)!! **And [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Keep Reading:**

- **[Excel Formulas to Count Total Characters in a Cell ~ Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-count-total-characters-in-a-cell/)**
- **[Excel Formulas to Count Total Characters in a Range ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-count-total-characters-in-a-range/)**
- **[Formulas to Get the Percentage of Total ~ Easily!!](https://geekexcel.com/excel-formulas-to-get-percentage-of-total/)**
- **[Excel Formulas to Count Total Words in a Range ~ Useful Tips!!](https://geekexcel.com/excel-formulas-to-count-total-words-in-a-range/)**
- **[Excel Formulas to Get the Total From the Percentage ~ Easy Ti](https://geekexcel.com/excel-formulas-to-get-the-total-from-the-percentage/)**[ps!!](https://geekexcel.com/excel-formulas-to-get-the-total-from-the-percentage/)