Calculating Sums in Excel

When it comes to summing up data in Excel, most people immediately think of using the SUM function. However, for simple data sets, such as a single column or row of data, there are other methods you can use to quickly and easily calculate sums. So what are some ways to calculate sums in Excel? Let's explore them below.

Here are 3 ways to calculate sums in Excel. You can use the method that best suits your needs to calculate sums quickly.

Method 1: Calculating Sums in Excel Using the Status Bar

Here's the quickest way to find the total of data in Excel. You can only view the total number of selected cells, you cannot copy the result.

On an Excel spreadsheet, simply select (highlight) the cells you want to total, or press Ctrl and select all the cells you want to total. Then, view the result on the status bar below in the Sum section.

Additionally, you can also see the total number of selected data cells in the Count section, and the average value of the total data in the Average section.

Method 2: Calculating Sums in Excel using AutoSum Feature

Using AutoSum, you can calculate the total of a column in Excel, and the result will be displayed directly on the spreadsheet. This feature only helps you calculate the total of one column. For calculating the total of multiple columns or different data ranges, this feature cannot be used.

Step 1: Select an empty cell just below the column of data you want to sum.

Step 2: Next, select the Home -> AutoSum tab.

Step 3: Now, in the empty cell you selected, the Sum function and the column range will automatically be selected. Simply press the Enter key.

Thus, you will have the sum result of the data column.

Method 3: Calculating Sums in Excel using the SUM function

The SUM function can calculate the sum of cells in a column, a row, or multiple columns, multiple rows, or a large range, various data ranges on an Excel spreadsheet.

Step 1: Select a blank cell to input the SUM function.

Step 2: Create the SUM function formula.

If you only have one column or one row of data to sum, follow these steps:

1. Enter =SUM(
2. Select the column/row to sum (or directly input the range of columns/rows to sum, for example, C6:C15).
3. Close ) and press Enter.

Here's the result you'll get:

If you have multiple different data ranges to sum, follow these steps:

1. Enter =SUM(
2. Select the first range (which is the first argument) you want to sum, you can directly input a range of columns/rows (for example, C6:C15).
3. Input ; to separate the arguments.
4. Select the second argument you want to sum, or directly input the range (for example, F6:F10).
5. Input ) and press Enter.

Here's the result you'll get:

Note: An argument can be a range, a number, a single cell reference, all separated by semicolons. Below are some examples of arguments in the SUM function.

=SUM(A4:A6;278; 5482) calculates the sum (sum from cell A4 to A6) + 278 + 5482.

=SUM(6523;A5:A8;C3:C5) calculates the sum of 6523 + (sum from cell A5 to A8) + (sum from cell C3 to C5).

=SUM(4823;3452;7852;C8:C10) calculates the sum of 4823 + 3452 + 7852 + (sum from cell C8 to C10).

=SUM(“1”;10;TRUE) calculates the sum of 1+10+1. The text value “1” is converted to the number 1, the value TRUE is converted to the number 1.

Above is the article sharing 3 methods for calculating totals in Excel. Hope this helps you. Wish you success!