How in Excel to calculate the amount?
Watch the video
Advanced user of our familiar packageprograms Microsoft Office understands that Microsoft Excel is not only a large and convenient table, but also a modern super calculator with a huge number of functions. In this small lesson we will teach you how to calculate the amount in excel.
As in excel, calculate the amount in the cell
If you need to insert an amount in the cellit is not necessary to calculate it in advance on a calculator. The main thing is to remember that you have to start any action in the cell with the = sign. For example, you need to count the sum of 5 + 7 in exel. Inside any cell, type: "= 5 + 7" and press enter.
Excel - how to calculate the sum of a column
- Click on the empty cell under the column.
- Hold down the shift key and click the up arrow. You have all cells in the column, the amount of which you need to calculate.
- In the top on the standard panel with different iconsfind the sum icon (it looks like this: Σ). Click on it. Congratulations, you counted the amount of the column in the excel! The result appeared in the cell below the column.