It is perhaps difficult to count exactly how many addition methods are implemented in Microsoft Excel. This is not surprising, since summation is a basic operation of any data analysis. This spreadsheet editor provides a ton of addition functions with a variety of additional filters to add values. Below are a few basic options that you will need to use the most.
It is necessary
Microsoft Excel spreadsheet editor
Instructions
Step 1
To solve the simplest problem - adding two numbers in a cell - proceed in the following sequence: - click an empty cell in the table; - enter the "=" sign. The editor will understand this as entering a formula into a cell; - type a math operation, for example 2 + 2. The entire contents of the cell should look like this: "= 2 + 2". If you need to add more than two numbers - enter as many as required, the rules do not change. For example, = 2 + 2 + 3 + 8 + 12; - when finished, press Enter. The spreadsheet editor will calculate the amount and show it in the same cell. You can use the SUM function instead of the arithmetic operator "+". It may look like this: = SUM (2; 2; 3; 8; 12).
Step 2
If you need a summation form from several cells for permanent use, then you can do it like this: - in a free cell, enter the first term number and press Enter; - in the next free cell, enter the second term and press Enter; - in the third, press the "=" and click the first cell (containing the first term). Then press "+" (addition operator) and click the second fold cell. As a result, the contents of the third cell with the formula will look like this: = A1 + A2. Press Enter, and the third cell will display the result of adding numbers. Now you can change the values in the cells to add, and the result in the third cell will change accordingly.
Step 3
The cells to be folded do not have to be only two - it can be an entire range in a row or column in a table. In this case, it is easier to use the hotkeys to enter the summation function (SUM). To do this, while holding down the SHIFT key, select the desired range of cells using the arrow keys and press the combination alt="Image" and =. In the cell following the selected range, Excel will write the function of summing the selected range. If you need to summarize the entire column or row, then you do not need to select it - just press alt="Image" and = in the cell next to the range.
Step 4
If you need to add the contents of cells scattered in unconnected areas of the table, then you will need to specify them manually. In the cell where you want to see the result of such a summation, press the "=" button, then click the cell with the first term, press the "+" button and click the cell with the second term, and so on. When all the cells to be summed are highlighted - press Enter.