WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android


How to add numbers in column in excel (Sum Formula Examples)

July 21, 2022

Microsoft Excel has evolved over time to improve user experience. Thus, several features and tools have been developed to make adding columns more efficient. With this tutorial, adding up columns of numbers together will be a piece of cake. This tutorial is for Excel beginners and experts. It will simplify data administration and familiarize you with Excel's powerful features. Learn how to easily add columns in Excel to boost productivity and save time.


If you are looking for a straightforward sum formula in Excel that can add numbers to a column? Then you have arrived at the right location! Even without having to calculate totals, working with data that is organized in columns and rows can be a challenge in and of itself.

With the extensive features offered by Microsoft Excel, regardless of whether the data you are working with is static or dynamic, merging multiple values together is actually much simpler of a task than it first appears to be.

Learn how to use Excel's robust features to calculate totals in both static and dynamic data sets. With our professional advice and tricks, say goodbye to the hassle of performing manual calculations and speed your data analysis. Start right now to fully utilize Excel's number-crunching powers.

Let's get started by discovering how fast and uncomplicated it is to total the items in a column when using Microsoft Excel.

Why Add Numbers in Excel?

When working with big data sets or performing financial computations, adding numbers in Excel is a crucial task. You can rapidly get the sum, the average, and other statistical functions that can help with decision-making and data analysis by adding the values in a column.

Particularly when working with a sizable volume of data, the manual procedure of adding numbers in a column could be difficult and could result in mistakes. Excel solves this problem by giving users a quicker and more precise way to add numbers.

Additionally, it makes it possible for users to categorize and analyze data more effectively. Excel is a complete tool for handling data and carrying out computations thanks to its built-in functions, formulae, and tools, such as the sum function.

Excel offers a simple way to add numbers and analyze the data for insights and well-informed decision-making, whether you are working with invoices, budget data, or sales figures.

WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
Algirdas Jasaitis

How to Add Numbers in a Column in Excel

When working with huge data sets, adding numbers in a column in Excel may seem like an onerous undertaking. But you can quickly and effectively calculate the sum of any column in Excel with the correct tools and a few easy steps only if you know where the autosum is in Excel.

Step 1

To begin, first choose the cell that will contain the total, then select the "Formulas" tab and click the "AutoSum" button.

How to sum rows in excel

How to sum rows in excel

When you want to add a range of cells, Excel will automatically choose those cells and display the total in the chosen cell.

Step 2

By entering "=SUM(column range)" in the formula bar, you can use the "SUM" function to add up a column that doesn't have an adjacent empty cell.

Advanced sum function in excel

Advanced sum function in excel

Step 3

You can compute the sum of just the cells that are visible in a filtered column using the "SUBTOTAL" function.

How to add number in excel

How to add number in excel

Powerful Excel tools like pivot tables and conditional formatting can further simplify the process of adding and evaluating data. You'll be able to add and modify data in Excel with ease after a little practice.

How to Add Numbers in a Column in Excel Shortcut

If you are short on time or just want to get things done faster,you can take help from sum a column in excel shortcut.

Step 1

Start by selecting all of the numbers in the full column that you want to add together.

Step 2

The "AutoSum" button can then be found by going to the Home tab, which is at the top of the Excel spreadsheet. This button can be found in the toolbar's "Editing" section and has the Sigma () symbol.

When you click on it, an automatic calculation will be made and the sum of the values in the highlighted column will be entered in the cell immediately below the column's final value.

This approach is highly effective for processing huge data sets quickly since it can handle both static and dynamic data.

shortcut SUM

shortcut SUM

Step 3

By highlighting the rows or columns you want to add together, you can utilize the "AutoSum" button to get the total of the numbers in several columns.

Once you get the hang of it, adding several numbers in Excel will be quick and simple. This shortcut can save a great amount of time and work.

how to sum a column in excel shortcut

how to sum a column in excel shortcut

Best Free Alternative - WPS Office

With a variety of features that make it simple for users to create and edit spreadsheets, WPS Office is a strong free alternative to Microsoft Excel. With a selection of layouts and customization options, it has an intuitive user interface.

The application is a potent tool for organizing data because it is compatible with widely used file formats like XLS and XLSX. Being able to manage pivot tables and charts, which makes it easier to organize and analyze data, is one of WPS Office's primary features.

Additionally, WPS Office includes the following features:

Notes: Can be used to add longer, more in-depth information that is not directly related to the data in the column or the entire spreadsheet. Can be accessed by placing your cursor on the little red triangle in the cell's corner.

Comments: Can be used to add more concise, precise information pertinent to the data in the cell. Can be accessed by right-clicking on the cell and selecting "Insert Comment". Are contained in a separate box and do not affect the spreadsheet's existing data and formatting.

Forms: Can be used to create interactive forms that can be used to collect data from users.

Macros: Can be used to automate repetitive tasks.

VBA: Can be used to create custom functions and add additional features to WPS Office.

Overall, WPS Office is a powerful and versatile tool that can be used for a variety of tasks. It is a great option for users who are looking for a free alternative to Microsoft Office.

WPS Office-The Perfect Alternative

WPS Office-The Perfect Alternative


1.How to Quickly Fill Numbers in Cells without Dragging?

It can be laborious and time-consuming to manually type numbers into each cell when working with a large data set in Excel. But do not worry, there is a quicker method to enter numerical values without dragging the cells.

With the help of Excel's 'Fill Series' tool, you can swiftly fill a range of cells with a collection of numbers in a certain order.

Step 1

To use this tool, simply select the cells that need values filled in, then enter the required start number and end number in the neighboring cells.

Step 2

Once you're finished, pick both numbers, then drag your cursor down as far as you need to until the crosshair appears in the bottom-right corner of the selection.

Excel will automatically insert the desired number sequence into the remaining cells.

Step 3

To fill in your series rapidly, you can also use the keyboard shortcut "Ctrl + Shift + Enter." This useful feature allows you to focus on more crucial areas of your work by saving time and removing the chance of human error.

Advanced sum function in excel

Advanced sum function in excel

2.What is the shortcut to SUM a column in Excel?

A column of numbers can be added up quickly and effectively in Excel by using the shortcut SUM a column.

Step 1

Choose the cell where you want the sum to show and enter the formula "=SUM(" followed by the range of cells you want to add up to use this shortcut.

For instance, to add the values in cells A1 through A10, enter "=SUM(A1:A10)" in the formula bar.

Step 2

When you hit enter, Excel will add the cells you've chosen and display the result in the cell you've chosen.

This shortcut can be adjusted to meet your unique needs in addition to being quick and simple. Rows, individual cells, and even non-adjacent ranges of cells can all be added using this method by simply separating the inputs with commas. Excel's SUM shortcut will speed up and simplify your data processing processes.

how to add sequential numbers in excel

how to add sequential numbers in excel

The Bottom Line

Microsoft Excel is a versatile data-management tool that can let us add numbers to columns. Excel has many ways to easily generate totals for static or dynamic data. In Excel, you can add numbers based on criteria, filter by conditions, or sum ranges using SUM, SUMIF, and SUMIFS.

Excel also lets you format totals using decimal places, currency symbols, and thousands separators to make them easier to understand. Due to its user-friendly interface and many features, Excel is a reliable and effective numerical data management tool.

As a student, professional, or business owner, knowing how to add numbers in a column in Excel can save you time and improve your data analysis. We encourage everyone to learn and master Microsoft Excel to maximize productivity.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.