How to Sum a Column in Microsoft Excel

Microsoft Excel offers several ways to sum the values ​​of a specific column. You can use the status bar, autosum and the SUM Function to add the values ​​in your column. Here’s how to use them.

TIED TOGETHER: How to add numbers in Microsoft Excel

Ways to sum the values ​​of a column in Excel

One way to sum a column is to use Excel’s status bar. If you only see the total and don’t want to show it anywhere in your spreadsheet, use this method.

The second method is to use AutoSum, an Excel function that automatically adds the SUM Function with required arguments to your selected cell.

Finally, you can use the popular one SUM Function to sum an entire column or specific rows or ranges within it.

View the sum of your column in Excel’s status bar

To show only the sum of your column, start your spreadsheet with Microsoft Excel.

In your spreadsheet, select the cells in your column for which you want to see the total. Then, to select your entire column, click the column letter at the top of your column.

In the bottom bar of Excel you will see the calculated sum of your selected cells next to “Sum”.

In addition, the status bar shows the number and average of your selected cells.

TIED TOGETHER: How to copy values ​​from the status bar in Microsoft Excel

Sum the values ​​of your column using Excel’s AutoSum function

To get the sum of the contiguous cells in your column, use Excel’s built-in AutoSum function. With this method, you select the cell at the end of your column values ​​and access the function, which is then filled SUM function with the necessary arguments for you.

To use it, first open your spreadsheet and click on the cell where you want to get the result. The function adds all values ​​above the selected cell.

With your cell selected, select AutoSum at the top of Excel’s Home tab.

In the cell you selected, AutoSum filled the SUM Function with your data area. When this looks good, press Enter.

You see the result of SUM function in your cell.

And you’re done.

Sum the values ​​of a column using Excel’s SUM function

Excel’s SUM Function is often used to add up the values ​​in your spreadsheets. You can use this function to add up specific cells, ranges of data, and even an entire column. This is the same as AutoSum, but we’ll show you how to enter it manually and change it to narrow down the choices.

To do this, first start your spreadsheet with Microsoft Excel and click on the cell where you want to see the result.

In your selected cell, type the following function and press Enter. Replace in this role C2:C22 with the area where your data is located. If you enter the function as is, all the numbers from will be added together C2 until C11 rows.

=SUM(C2:C11)

To count values ​​from specific column cells, add your cells in SUM Function separated by a comma as follows:

=SUM(C2,C5,C8)

To add a range and specific cells, use the SUM work as follows:

=SUM(C2:C5,C8,C10)

To sum an entire column, use the column letter in the SUM Argument of the function as follows. You want to use this function in a cell that is in a different column.

=SUM(C:C)

You’ll see all the rows in your selected cell added together.

As you can see, adding numbers from your columns in Microsoft Excel is as easy as using a built-in function or typing it in manually SUM Function. We hope that our guide will help you.

---

Want to calculate sum of squares in Excel? If so, is there a way to do it.

TIED TOGETHER: How to calculate sum of squares in Excel