Home  >  Article  >  Software Tutorial  >  How to automatically sum totals in excel

How to automatically sum totals in excel

王林
王林forward
2024-03-20 12:20:071253browse

In Excel, automatic summation is a very practical function that can greatly improve work efficiency. How to implement automatic summing of totals in Excel? PHP editor Yuzai will introduce it to you in detail. By using Excel's built-in function SUM, you can easily sum numbers within a specified range. In addition, you can also use the shortcut Alt = to quickly sum selected cells. Mastering these methods can help you complete data statistics work in Excel tables more efficiently.

excel automatic sum:

First, we need to add the numbers in cell A1 and cell B1, and display the result in cell C1. To do this, first enter the numbers you want to add in cells A1 and B1. Next, select cell C1 and enter the following formula: `=A1 B1`. After pressing the Enter key, cell C1 will display the sum of the numbers in cells A1 and B1.

How to automatically sum totals in excel

##2. Excel client - 2021 version free download View details>> Advertisement 2 First, we select cell C1, and then enter " =A1 B1", and then press the "Enter key" on the keyboard. The result of the addition and summation will be displayed in the "C1" cell (as shown below):

How to automatically sum totals in excel

3. Batch calculation of multiple rows or columns in an Excel table The method is basically the same as the above method, but even simpler. First, we need to add the two cells A1 and B1 to sum. Select cell C1, enter "=A1 B1" in the "edit bar", and press Enter. Move the cursor to the lower right corner of cell C1 until the cursor turns into a black cross. Press and hold down the left mouse button and drag it to the bottom. At this time, all the addition results in columns A and B will be displayed. Column C (as shown below):

How to automatically sum totals in excel

excel automatically sums the columns:

1. In the three cells A1, B1, and C1 Fill in any three columns of data according to the serial numbers, then use the mouse to hold down the first cell A1 and drag it to the last serial number of cell C1 (as shown below):

How to automatically sum totals in excel

2, At this time, the columns of numbers in these three cells are automatically summed, and the sum is displayed in the lower right corner of the Excel table. In this way, the sum of all the numbers in the three vertical and horizontal columns is calculated (as shown below).

How to automatically sum totals in excel

The above is the detailed content of How to automatically sum totals in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:huke88.com. If there is any infringement, please contact admin@php.cn delete