Excel Formulas To Calculate Total columns in the range in Excel 365?
Tags: excelformula, excelformulas
Published: 2021-10-26 10:26:08

---
title: Excel Formulas To Calculate Total columns in the range in Excel 365?
published: true
date: 2021-10-25 13:14:07 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-total-columns-in-the-range-in-excel-365/
---

If you want to learn how to ** calculate total columns in the range** in Excel 365? This post will give you an overview of how to do so using the  **COLUMNS** Function in Excel, and it provides some simple formulas to help you quickly get it done. Let’s jump into this post!! 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

- Use the below-mentioned formula to calculate total columns in the range.

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

```

## Syntax Explanation

- **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.
- **Rng ** – It represents the input range.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example

Use the following steps to calculate total columns in the range in Excel.

- In the following example, you have a **sample data**  in Microsoft Excel.

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

- Then, to count the total number of **columns in a range in rows** , 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/)**.

```
=[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-Formula-for-rows.png)<figcaption>Use 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-rows.png)<figcaption>Result for rows</figcaption>

- After that, to calculate total number of columns in a range in **columns** , 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/)**.

```
=[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-formula-for-Columns.png)<figcaption>Use 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-Column.png)<figcaption>Result for column</figcaption>

- Now, to calculate total number of columns in a 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/)**.

```
=[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-Formula-for-cells.png)<figcaption>Use 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-1.png)<figcaption>Result for cells</figcaption>

## Bottom-Line

Hope you understood the simple formula to **calculate total columns in the [range](https://geekexcel.com/how-to-calculate-the-range-contains-a-specific-date-in-excel/)**in Excel 365. Let me know if you have any  **doubts**  regarding this post or any other article on this site and share this post with others that can benefit from it! To learn more, check out our website **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Further Reference:**

- [How To Calculate Total cells in a range in Excel Office 365?](https://geekexcel.com/how-to-calculate-total-cells-in-a-range-in-excel-office-365/)
- [Excel Formulas to Count Total Characters in a Cell ~ Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-count-total-characters-in-a-cell/)
- [Formulas to Count Total Characters in a Range ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-count-total-characters-in-a-range/)
- [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 Percentage of Total ~ Easily!!](https://geekexcel.com/excel-formulas-to-get-percentage-of-total/)