How does Excel add continuously?

Use the sum function.

Can. For example, =a1+a2+a3+a4 can be written as =sum(a1:a4).

Introduction and example of the sum function:

Purpose: Returns the sum of all numbers in a range of cells.

Syntax: sum(number1,number2,..

Parameters: number1, number2,..1 to 30 values (including logical values and literal expressions) that need to be summed.

Region or Reference.

Note: The numbers, logical values, and text expressions of the numbers in the parameter table can be used in the calculation, where the logical values are converted to 1 and the text is converted to numbers. If the parameter is an array or reference, only the numbers in it will be evaluated, and blank cells, logical values, text, or error values in the array or reference will be ignored.

Example: If a1=1, a2=2, a3=3, then the formula "=sum(a1:a3)" returns 6; =sum("3",2, true) returns 6, because"3"is converted to the number 3, and the logical value true is converted to the number 1.

It's all in the same column, so select the cell A101, and then find the sum formula.

1. First of all, enter several sets of data that need to calculate continuous addition and subtraction in Excel**, for example, you need to calculate column A data plus column B data minus column C data.

2. Hu Oak then enter the calculation formula of addition and subtraction in cell D1: =A1+B1-C1, and you need to hold down the shift button when entering the addition symbol.

3. Then click Enter.

You can generate the result of the calculation formula, and you can see that the addition and subtraction result "-2" has been obtained in cell d1 at this time.

4. If you need to generate the calculation results in batches, you can fill the formula of cell d1 down for quick calculation.

1. First of all, enter several sets of data that need to calculate continuous addition and subtraction in Excel**, for example, you need to calculate column A data plus column B data minus column C data.

2. Then enter the calculation formula of addition and subtraction in cell D1: =A1+B1-C1, and you need to hold down the shift key when entering the addition symbol.

3. Then click the enter key to generate the calculation formula, and you can see that the addition and subtraction calculation result "-2" has been obtained in the d1 cell at this time.

4. If you need to generate the calculation results in batches, you can fill the formula of the d1 cell hidden down for quick calculation.

Suppose you want =a1-b1-c1-d1-e1-f1-g1, then the formula can be written as =a1-sum(b1:g1).

For example, in the A1 to A5 region and the B6 cell format, A1 to A5 are 1, 2, 3, 4, 5, and B6 is 6

Addition =sum(a1:a5,b6).

a1+a2+a3+a4+a5+b6

A1 to A5 and B6 add up to 21

Subtraction =sum(a1:a5)-b6

a1+a2+a3+a4+a5-b6

The addition of A1 to A5 minus B6 is 9

Multiplication =product(a1:a5,b6)=a1*a2*a3*a4*a5*b6

The multiplication of A1 to A5 and B6 is 720

Division = product(a1:a5) b6=a1*a2*a3*a4*a5 b6

Multiply a1 to a5 and subtract b6 to 20

The cells that are entered into the formula cannot be cells that have been referenced in the formula, so as not to form a loop to calculate the cell name (also known as the address).

There is a horizontal row of a, b, c, d in **... Such letters, each letter represents a column, called the column label, there is a vertical row of numbers on the side, called the row number, each number represents a row, the column and the row form the cell address, for example, the first cell (that is, the cell where A and 1 intersect) refers to the A1 cell, the cell where B and 2 intersect is called B2 cell, and the cell where C and 5 intersect is C5 cell.

Let the initial value you need to subtract is 500, subtracting 1 each time. In the first cell you need, type:

501-row(a1)

Then pull down and fill it.

First, this can be done with the sum function with the $ absolute reference symbol.

For example, you want to get the value of cell A1 in cell B1, the value of A1+A2 in cell B2, the value of A1+A2+A3 in cell B3, and the value of A1+A2+A3+A4 in cell B4.

Then you can write the formula in cell b1.

sum(a$1:a1)

Drop-down fill formula.

2. The meaning of the relevant functions and symbols in the formula.

1) sum function.

2) $ absolute reference symbol.

a1 is a relative reference, $a1 absolute reference column is a mixed reference, a$1 absolute reference row is a mixed reference, $a$1 absolute reference row and column are absolute reference.

Whoever is in front of it is absolutely quoted.

F4 is a shortcut to and from four types of references (you can switch between pressing the F4 function key while entering a formula in a field).

A1 (relative reference) When you drag a reference down, it becomes a reference A2, A3, A4, etcWhen you pull and drag to the right, the reference becomes b1, c1, d1....

a$1 (mixed references) When you want to make sure that only the A1 cell is referenced when you pull down and copy, you need to add the $ sign to A$1 to make A$1, so that you can ensure the relative reference to the first row of column A when you pull down (that is, keep the line number unchanged when referencing).

A1 (Mixed References) When you pull right to copy and want to make sure that only the A1 cell is referenced, A1 should add the $ sign to $A1, so that when you pull right, you can ensure that the relative reference to the first row of column A (that is, keep the column label unchanged when referencing).

a$1 (absolute reference) When you want to make sure that only the A1 cell is referenced when you pull down and pull right, you need to add the $ sign to $a$1, so that the absolute reference to the first row of column A can be guaranteed during the pulldown and right pull (that is, the row number column label will not change when referencing).