Suppose you have the fields Expenses, Salary, or any numerical fields in your table. You may need to report the sum of a column of numbers.
In this post, you learn 4 different ways to sum a column of numbers in Excel
Just Click to Sum a Column
![](https://i0.wp.com/pptexcel.com/wp-content/uploads/2022/12/img_002-7.png?resize=594%2C332&ssl=1)
Just select the respective column in excel and see the sum in the status bar of your excel application.
Use AutoSum to Sum a Column
Please follow the below steps to use AutoSum in Excel
![](https://i0.wp.com/pptexcel.com/wp-content/uploads/2022/12/img_003-6.png?resize=899%2C269&ssl=1)
Select the last cell C12
Go to Home, Click AutoSum and Press Enter
Use the SUM Function to Sum a Column
SUM Function is one of the basic Excel function. It helps to simply sum up the numbers in a selection of cells. It may be used to add up all the data in a column or row, or to determine the total of a range of numbers.
![SUM Function](https://i0.wp.com/pptexcel.com/wp-content/uploads/2022/12/img_004-3.png?resize=325%2C289&ssl=1)
Go to cell C12, Type the formula =SUM(C2:C11) and Press Enter
The SUM function sum the salary of all the employees in cell C12.
Use Excel Table Feature to sum a column
The spreadsheet application Microsoft Excel includes a feature called Excel tables that is tremendously helpful. Tables are used to arrange and store data in a tabular style, much like a spreadsheet, but with extra functionality like sorting and filtering.
![Excel Table](https://i0.wp.com/pptexcel.com/wp-content/uploads/2022/12/img_005-2.png?resize=266%2C390&ssl=1)
Select the range of cells B1:C11, Go to Insert and Click Table
Once you convert the data to a table.
![](https://i0.wp.com/pptexcel.com/wp-content/uploads/2022/12/img_006.png?resize=768%2C341&ssl=1)
Go to Table Design, Select the Total Row.
Now you can see the sum of salary in the Total row.
Conclusions
It is easy to add a column of numbers in Excel by following a few straightforward steps.
The SUM function is a very useful tool for quickly performing calculations in Excel. It can be used to easily add up the values in a range of cells, and can be used in conjunction with other functions to give users a better understanding of their data.
If you have any questions, please leave a comment below and I will get back to you as soon as possible.