How to Calculate the Table Columns in Excel ~ A Useful Guide!!
Tags: excelpreface, calculatethetablecol, excelbasics, exceltutorials
Published: 2021-01-03 16:42:14

---
title: How to Calculate the Table Columns in Excel ~ A Useful Guide!!
published: true
date: 2021-01-03 16:23:59 UTC
tags: ExcelPreface,calculatethetablecol,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/calculate-the-table-columns-excel/
---

We have already seen how to calculate [sum](https://geekexcel.com/calculate-sum-without-formula/), [average](https://geekexcel.com/find-average-excel-without-using-formula/), [min](https://geekexcel.com/how-find-smallest-number-without-formula-excel/), and [max](https://geekexcel.com/find-largest-number-excel-without-using-any-formula/) values in Excel by using the commands. In this tutorial, we are going to learn how to **calculate the table columns in Excel**. Let’s get into this article!! 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)
## Steps to calculate table columns:

Just follow the steps below to calculate the values in the table columns. Here, we will see how to get the [sum of the rows](https://geekexcel.com/calculate-sum-without-formula/) in the table.

- First, you need to create a table and select the cells below the table.

![Select cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Select.png)<figcaption id="caption-attachment-20596">Select cells</figcaption>

- Then, click the **“Home”** tab from the **“[Ribbon](https://geekexcel.com/use-and-customize-ribbon-commands-in-excel-office-365-quick-ways/)“**.

![Home tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Home-tab.png)<figcaption id="caption-attachment-20597">Home tab</figcaption>

- You can see the **“AutoSum”** option from the **“Editing”** section.
- Here, you need to click the **“Sum”** option to get the sum of each column.

![AutoSum](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Select-Sum.png)<figcaption id="caption-attachment-20598">AutoSum</figcaption>

- It will calculate the sum of the column and [display](https://geekexcel.com/how-to-show-or-display-all-cell-formulas-in-excel-office-365/) it in the selected row as per the given image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-3.png)<figcaption id="caption-attachment-20599">Result</figcaption>

- Likewise, you can calculate different measures such as average, max, min, and count.
- To change into different calculations, you need to click the cell with the total.
- Then, you need to click the triangle on the right corner of the cell and select the measurement from the drop-down list.

![More functions](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/More-functions.png)<figcaption id="caption-attachment-20600">More functions</figcaption>

## Verdict:

So this is how you can get the **calculated value in the table columns in Excel**. Please share your query below in the comment box. We will assist you. ![🙏](https://s.w.org/images/core/emoji/13.0.1/72x72/1f64f.png) Thank you so much for visiting our site!! To learn more, check out **[Geek Excel](https://geekexcel.com/)****!!**

### Read Ahead:

- **[Excel Shortcut: INSERT TABLE in the Worksheet in Excel 365!!](https://geekexcel.com/ms-excel-shortcut-to-insert-table-in-the-worksheet/)**
- [**Select Table Row Using Shortcuts in Microsoft Excel 365!!**](https://geekexcel.com/shortcut-keys-to-select-table-row-in-microsoft-excel-365/)