Excel Formulas to Count table columns in Excel 365!!
Tags: excelformula, excelformulas
Published: 2021-10-28 04:17:50

---
title: Excel Formulas to Count table columns in Excel 365!!
published: true
date: 2021-10-27 02:06:57 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-table-columns-in-excel-365/
---

Earlier, we have learned the formulas to **[count the unique text values in a range in Excel](https://geekexcel.com/formulas-to-count-unique-text-values-in-a-range-in-excel-office-365/)**. Here, we will guide you to learn the simple and useful  **formulas to**  **count the table columns** in Excel 365. You can also learn the basic syntax with brief explanations. Let’s see them below!! 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 count the table columns.

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

```

## 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.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Table** – It contains list of values.

## Practical Example

Use the following steps to count the table columns 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-54.png)<figcaption>Sample data</figcaption>

- Then, to count the total number of **columns** in table, 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/)(Table1)

```

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

- Now, you will get the result for the column in the **cell I5** as given below.

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

## Verdict

In this tutorial, we explained the  **formulas to count the table columns in Excel 365**. Hope that this tutorial is useful to you. Mention your  **queries**  in the  **comment**  box below. Click here to know more about **[Geek Excel](https://geekexcel.com/)!! **And [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! ** Thank you so much for visiting!!

**Read Next:**

- **[Convert a Table to the Data Range in Excel Office 365!!](https://geekexcel.com/convert-table-to-data-range/)**
- **[Excel Formulas to Count the Values that appear in a List!!](https://geekexcel.com/excel-formulas-to-count-the-values-that-appear-in-a-list/)**
- **[Excel Shortcut: INSERT TABLE in the Worksheet in Excel 365!!](https://geekexcel.com/ms-excel-shortcut-to-insert-table-in-the-worksheet/)**
- **[Shortcut to SELECT TABLE in Microsoft Excel 365!](https://geekexcel.com/keyboard-shortcut-to-select-table-in-microsoft-excel-365/)**
- **[Select Table Row Using Shortcuts in Microsoft Excel 365!!](https://geekexcel.com/shortcut-keys-to-select-table-row-in-microsoft-excel-365/)**