How to Calculate Totals in Excel

This guide explains how to calculate Totals in Excel, with clear steps, practical tips, and important checks before you begin.

Here are 3 ways to calculate totals in Excel, you can use the appropriate methods for each case to get the fastest total.

Method 1: Calculate sum in Excel by status bar

This is the fastest way for you to know the total numbers in Excel, you can only see the total number of cells you select is not able to copy that result.

On an Excel worksheet, simply select (highlight) the cells to sum or press Ctrl and select all cells to sum. Then you see the results in the status bar below in the Sum .

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

Method 2: Calculate totals in Excel using the AutoSum function

Using AutoSum you can sum a column in Excel, and the results will be displayed immediately on the worksheet. This function only helps you sum a column, but for the calculation of multiple columns, different data regions, this function does not work.

Step 1 : Select the blank cell immediately below the column of data you want to sum.

Step 2: Next select tab Home -> AutoSum.

Step 3: At this time in the selected cell, the Sum function will appear and the column column area will be automatically selected. You just need to press the Enter key.

Thus, you will have the result of calculating the total of the data column.

Method 3: Sum in Excel using the SUM function

The SUM function can sum cells in 1 column, 1 row or multiple columns, multiple rows or a large range, different data ranges on Excel spreadsheets.

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

Step 2: Create the SUM function formula.

If there is only one column or 1 row of data to calculate, do the following:

1. Enter = SUM (
2. Select the column / row to be summed (or you enter the column / row area to be calculated directly (for example, C 6: C15 ).
3. Close ) and press Enter.

Your results will be as follows:

If there are many different data areas to be summed, you should do the following:

1. Enter = SUM (
2. Select the range (which is the argument) first to calculate the total, you can enter the column / row directly (for example C6: C15 ).
3. Enter the sign ; to separate arguments.
4. Select the second argument to calculate the total, or you enter the range directly (eg F6: F10 ).
5. Type a ) and press Enter .

Your results will be as follows:

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

= SUM (A4: A6; 278; 5482) sums (sums from A4 to A6) + 278 + 5482.

= SUM (6523; A5: A8; C3: C5) totals 6523 + (sum from cell A5 to cell A8) + (sum from cell C3 to cell C5)

= SUM (4823; 3452; 7852; C8: C10) sums the numbers 4823 + 3452 + 7852 + (sums from cells C8 to C10).

= SUM ('1'; 10; TRUE) sums 1 + 10 + 1. Text value '1' is converted to number 1, TRUE value is converted to number 1.

Above the article has shared with you 3 ways to sum in Excel, hope this article will help you. Good luck!