We learn how to calculate the amount in Excel

However users treat changes related to office programs, the fact remains that they were, are and will be, and therefore have to adapt to their rather changeable appearance. As you already understood, we are talking about the latest versions of MS Office, which are very different from their predecessors. Let's see if only the appearance was limited to the developers this time.

The Russian language has finally become one of the listed ones, so there is no need to worry about the difficulties of translation. In addition, programmers for some time kept their promise and rolled out to the public a full-fledged x64 version. However, they honestly warn that if you do not need to work with Excel files of 2GB or more, it is desirable to use a morally obsolete 32-bit version.

Let's leave the lyrics aside. Today we will learn how to calculate the amount in "Excel". Yes, for experienced users there is nothing complicated in this, but still most of the newcomers never encountered this.

Process of calculation

For the sake of justice it is worth noting that calculating the total values is one of the simplest operations with formulas that only exists in this spreadsheet editor. Let's analyze the most elementary example.

Suppose that the work is done in a column in the range from A4 to A9. Before calculating the sum of these values in Excel, you only need to select all these cells and one empty under them (that is, the range from A4 to A10), and then click on the sum button. The program automatically calculates the result and puts it in cell A10.

There is another way. Suppose that the desired values are available in the same cells. But you may need to have the desired result in a cell from another range (B7, for example). How can this be achieved?

First select cell B7 with the left mouse button, then click on the sum button. Then, with the left mouse button, specify the range that contains the data you need. The final value appears in the resulting cell. If necessary, the range of allocated cells can be changed.

More complex option

All that we have considered above, refers to the category of those commonplace data that give students at the first lessons of computer science. But how to be in the case when the sought-for value should be obtained on the basis of data that is in completely different ranges?

Before you calculate the amount in such conditions, you'll have to do a little more. First we put the cursor in the cell where the total amount will be. Put the "=" sign there, then select the cell with the left mouse button, the value of which should be added to the other digits.

After the "equal" sign, its value will appear (A6, for example). Put after the A6 sign "+", continue to mark the range you need. When finished, simply press the "Enter" key: the desired value appears in the desired cell.

"Quick amount"

And how in "Excel" to calculate the amount, if you only need to quickly look at the total value of several cells, without collecting complex expressions for this? Well, the creators of this software complex (call it a utility does not turn the language) also provided for this scenario.

At the very bottom of the worksheet there is a line with the word "Done". We click on it with the right mouse button, and in the drop-down context menu we select the "Sum" item. After that, you need to select the required range of cells with the left mouse button while holding down the Ctrl key on the keyboard.

Where to find the answer?

Selecting the cells and releasing the key on the keyboard, pay attention to the lower right corner of the working window: there will be a line "Sum =", which indicates the resulting value.

As you can see, you do not need to use the calculator for intermediate calculations, since Excel easily overplays it with all indicators. Yes-yes, since in Excel it is not possible to calculate the amount, but accountants with experience often use this technique.

Another way

If you carefully read our article, you probably paid attention to the number of formulas used in the calculations. Yes, you are right: if you independently enter them in the appropriate field, you can not touch the mouse at all. Let's look at how this is done in practice.

In order for you to get the formula in Excel (the amount without words in it will not work), you first need to know about where to enter it at all. Just under the toolbar (or under the tape in new versions) there is a long field. In its beginning there is an Fx badge, so you can not go wrong.

That's it, and the required functions are entered. Suppose that you need to know the sum of a number of cells that are evenly distributed across the table. First, select the field in which the equation will be calculated. After that, we write in the field of the formulas "=", and then register those cells that contain the required data, separating them with the "+" sign.

For example: = A1 + B2 + C3. When you're finished typing, click on the ubiquitous Enter. The desired number appears in the field you selected. As in "Excel" it is often required to calculate the amount in this way, you must remember about it.