Microsoft Excel is a very convenient tool for performing various mathematical calculations. It can be used to perform calculations, create graphs, data tables, etc. When studying this program, questions often arise about the application of certain formulas.
There is no problem in how to calculate the amount in Excel. The developers were worried about how to do this in several ways at once. Having studied and understood them, you can choose the most convenient method for yourself and use only it in the future.
In the simplest case, you need to write in a cell the formula = X + Y + Z …, where instead of X, Y, Z, the desired numbers or cell numbers are indicated. Cell numbers can be either manually assigned or indicated by clicking the left mouse button.
You can also use a more complex formula: = sum (X; Y; Z) or = sum (X: Z). In the first case, numbers are indicated by enumeration, and in the second, you can specify a range from one cell to another.
In addition, if you select several cells with numerical data, then their sum will be indicated in the information line located at the bottom of the screen. This is very convenient for quick browsing that does not require writing any formulas.
Another way to calculate the amount. If you select several cells with numbers and press the "AutoSum" button located in the "Formulas" tab, then Microsoft Excel will calculate their sum and write the calculated value into the cell next to the selected ones.
These are the easiest ways to calculate the sum in Excel. For more complex calculations, you can add numbers that meet certain criteria, as well as perform more complex calculations.
