Home  >  Article  >  Topics  >  How to calculate addition in excel

How to calculate addition in excel

藏色散人
藏色散人Original
2020-03-09 09:29:187145browse

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"

How to calculate addition in excel

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:

How to calculate addition in excel

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:

How to calculate addition in excel

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.

How to calculate addition in excel

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

How to calculate addition in excel

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:

How to calculate addition in excel

How to calculate addition in excel

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.

How to calculate addition in excel

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:

How to calculate addition in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn