Automatic accumulation in Excel is very useful, such as making reports, including today's balance and cumulative balance. So how to use automatic accumulation, let’s take a look.
What is excel’s automatic accumulation formula?
The formula used for automatic accumulation isSUM.
The specific usage is as follows:
1. If you want to add up all cells from A1 to E1 and write the cumulative result in cell F1, enter "=SUM in cell F1 (A1: E1)”
Recommended learning:EXCEL Basic Tutorial
2. Press the Enter key to confirm.
#3. At this time, all the values in cells A1 to E1 will be automatically accumulated, and the result will be displayed in cell F1.
4. Let column accumulation be similar to row accumulation. If you want the values from A1 to A9, write the result to A10, in cell A10 Enter the formula "=SUM(A1:A9)".
#5. After understanding row accumulation and column accumulation, let’s take a look at area accumulation. If we want to accumulate A1 to A5, B1 to B5, C1 to C5 The value in the cell, and write the cumulative result of the value into D6. Enter the formula "=SUM (A1:C5)" in cell D6 and press the Enter key.
#6. To enter the formula, you can also select the cell where the result is to be displayed and enter it in the input box above the table. After the input is completed, click the "green button" in front of it. Check" to confirm.
For more excel related tutorials, please pay attention toPHP Chinese website!
The above is the detailed content of What is the automatic accumulation formula in excel?. For more information, please follow other related articles on the PHP Chinese website!