How to calculate addition in excel

How to calculate addition in excel?

This article takes excel in wps as an example. First, open the arithmetic addition document you need. As shown below:

Recommendation: "excel tutorial"

Just use the sum tool directly to sum. First, use the mouse to select the blank table below the column of numbers you want to sum. As shown below:

Then, in the menu bar above the table, select the summation tool. Generally, it is displayed directly in the "Start" menu. If not, see See if you have not selected Start. After you find it, left-click the mouse to select it, as shown below:

After selecting, you will find that the column you selected has changed. There is a blue box to select your column. If you find that there are still numbers that are not selected, you can also select them by yourself. Just select from the top to the bottom of the column of the numbers you want to sum. You will also find that the number after selection is Select it with a blue box.

After selecting everything, click the "Enter key" to calculate the result.

Sometimes you may need to add the same number to this column and calculate the result. In this case, just use the formula to calculate in the box next to each number. Yes, the formula is: "=The number that needs to be added to the column where the original number is located" For example: "=C1 58" This C1 can select this table with the mouse, as shown below:

Then click Enter, and the sum of the added numbers will be calculated. If you want to add this number to this column, just select the summed number, and then put the mouse on the table In the lower right corner of the table, you will find that the mouse becomes 'black'. Hold down the left mouse button and pull down, and you will find that all tables are summed according to this number.

To verify whether it is added according to this "58", just click on any table after the sum and take a look. As shown below:

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