Current location - Education and Training Encyclopedia - Resume - How to set the formula of automatic summation of tables
How to set the formula of automatic summation of tables
Automatic summation, addition formula and other methods, the following are the steps of automatic summation:

Tools/materials: Huawei MateBook 14s, Windows 10, Excel1491.205438+032.

1, click the formula

In Excel software, click the formula option above to enter the formula ribbon.

2. Click Auto Sum.

On the Formula ribbon, click the Auto Sum option to use the formula.

3. Press Enter.

After using the formula, drag the mouse to select the content of the sum, and press Enter to automatically sum.

Method 2

1, enter equal sign.

In the blank cell of Excel, enter the equal sign, and then click the cell with the number.

2. Enter the plus sign

After selecting, enter a plus sign in the cell, and then click the second cell with a number.

3. Press Enter.

After the selection is completed, press Enter on the keyboard for automatic summation.