Buzz
What function to use for summing in Excel? As many are aware, Excel is spreadsheet software part of the Microsoft Office suite designed to help record, present data in tabular form, integrating various functions for calculations and building visual statistics in Excel. The simplest calculation in Excel is summing using the SUM function which everyone must use when dealing with calculations. We invite readers to refer to various ways to sum in Excel quickly using the SUM function that we have compiled in the following article.
Summing in Excel 2003, 2016, 2013, 2007, 2010
Method 1: Excel Totaling Based on Status Bar
This is the quickest way to sum in Excel vertically or horizontally. Simply click on the characters of the column or use the mouse to select the cells you want to sum, then look at the Excel Status Bar to see the sum of the selected cells. However, with this method, you cannot copy, you can only view.
Method 2: Excel Totaling using AutoSum
If you want to sum a column in Excel and keep the result in your table, you can use the AutoSum feature. It will automatically add up the numbers and display the total in the cell you select. This method is quick and allows you to automatically receive and retain results in the table.
Step 1: First, click on the empty cell below the column where you want to display the sum result.
Step 2: Go to the Home tab in the Editing group and click on the AutoSum button.
Step 3: Immediately, you will see Excel automatically adds =SUM and selects the range of your data column.
Step 4: Now you just need to press Enter on the keyboard to have the sum result in Excel.
Method 3: Excel Totaling using SUM function
With this method, you can sum the numbers of cells in a column or specify an address for a large range instead of manually selecting them.
Step 1: Click on the cells in your table that you want to see the sum of the selected cells.
Step 2: Enter =sum( into this selected cell.
Step 3: Now select the range with the numbers you want to sum by holding Ctrl and clicking on the data cells then press Enter.
Note: You can manually input the address like =sum (B1: B2000). It's very useful if you have a large data range to calculate.
After pressing Enter, the sum result will appear in the cell you selected.
Attention:
* For conditional summing in Excel, you just need to apply the following function: =SUMIF(range, criteria,sum_range)
Where:
- Range: The selected range containing condition cells.
- Criteria: Condition to perform sum function.
- Sum_range: Range to calculate sum.
* To avoid errors in Excel summing, make sure to input the correct function.
Moreover, at a higher level of summing arising from practical needs when data is aggregated from a list with various entries. In this case, in a data field column, values appear more than once, and each occurrence corresponds to a different value in the adjacent column. To be able to sum with such data blocks, you use the SUMIF function, interested readers can refer to the guide on how to use SUMIF function previously shared by Mytour.
Thus, with the Excel summing methods we introduced here, we hope you can choose for yourself the simplest and fastest summing method that suits each situation. In some cases, when users use Excel to sum data, many encounter some annoying errors such as unable to use SUM function or SUM result equals 0 in Excel. Readers can refer to how to fix SUM function errors in Excel as we instructed earlier as well as fix SUM result equals 0 error. Wish you success.
As for the quotient function, it's also very easy, you can use this function in your studies or for your work. They will help you produce results quickly and accurately.
- See more: Quotient function
