How to calculate totals in Excel

When it comes to summarizing in Excel, you often think of using the SUM function to sum the data in Excel. But there are many cases where a simple data area, just a column or a row of data, you can use other ways to quickly and simply sum. So there are ways to calculate the total in Excel, please refer to the following article.

How to calculate totals in Excel Picture 1

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 .

How to calculate totals in Excel Picture 2

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 to 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.

How to calculate totals in Excel Picture 3

Step 2: Next select tab Home -> AutoSum.

How to calculate totals in Excel Picture 4

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 .

How to calculate totals in Excel Picture 5

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

How to calculate totals in Excel Picture 6

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.

How to calculate totals in Excel Picture 7

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.

How to calculate totals in Excel Picture 8

Your results will be as follows:

How to calculate totals in Excel Picture 9

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 .

How to calculate totals in Excel Picture 10

Your results will be as follows:

How to calculate totals in Excel Picture 11

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!