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. 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

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 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.

Sample data

• Then, to count the total number of columns in table, you need to use the below given formula in the formula bar.

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

Use the Formula

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

Output

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!! **And Excel Formulas *!! ** Thank you so much for visiting!!

Read Next:

• Convert a Table to the Data Range in Excel Office 365!!
• Excel Formulas to Count the Values that appear in a List!!
• Excel Shortcut: INSERT TABLE in the Worksheet in Excel 365!!
• Shortcut to SELECT TABLE in Microsoft Excel 365!
• Select Table Row Using Shortcuts in Microsoft Excel 365!!