No matter how users relate to changes related to office programs, the fact remains: they were, are and will be, and therefore they will have to adapt to their rather variable 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 the developers were limited in appearance this time.
The Russian language has finally become one of the ones on the list, so you should not worry about the difficulties of translation. In addition, programmers for some time kept their promise and rolled out a full x64 version to the public. However, they honestly warn that in the absence of the need to work with Excel files of 2 GB or more, it is more desirable to use the obsolete 32-bit version.
Leave the lyrics aside. Today we will learn how to calculate the amount in Excel. Yes, for experienced users this is not a big deal, but still most of the newcomers have never encountered this.
Calculation process
In fairness, it is worth noting that the calculation of the total values ​​is one of the simplest operations with formulas, which is only in this table editor. Let's analyze the most elementary example.
Assume 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 cell below them (that is, the range from A4 to A10), and then click on the sum button. The program will automatically calculate the result and put it in cell A10.
There is another way. Suppose the desired values ​​are in the same cells. But you may need the result to be in a cell from a different range (B7, for example). How to achieve this?
First, select cell B7 with the left mouse button, and then click on the sum button. After that, the left mouse button indicates the range in which the data you need is contained. The desired value appears in the final cell. If necessary, the range of selected cells can be changed.
More difficult option
Everything that we examined above belongs to the category of the banal information that is given to students in the very first lessons of computer science. But what if the desired value should be obtained on the basis of data that are in completely different ranges?
Before calculating the amount in Excel under such conditions, you will have to do a little more. First, put the cursor in the cell in which the total amount will be. We put the “=” sign there, after which we select the cell with the left mouse button, the value of which should be added to other numbers.
After the equal sign, its value will appear (A6, for example). We put the “+” sign after A6, continue to mark the range you need. When done, just press the “Enter” key: the desired value will appear in the desired cell.
"Quick Amount"
But how to calculate the amount in Excel , if you just need to quickly look at the total value of several cells without collecting complex expressions for this? Well, the creators of this software package (to call it a utility does not rotate the language) have provided such an option for the development of events.
At the very bottom of the worksheet there is a line with the word “Finish”. We click on it with the right mouse button, and select the “Amount” item in the pop-up context menu. After that, you need to select the required range of cells with the left mouse button while holding down the Ctrl button on the keyboard.
Where to look for an answer?
Having selected the cells and releasing the key on the keyboard, we pay attention to the lower right corner of the working window: there will be a line “Amount =”, in which the resulting value is indicated.
As you can see, you don’t need to use a calculator for intermediate calculations, since Excel easily outperforms it in all respects. Yes, yes, since not everyone can calculate the amount in Excel, accountants with experience often use this particular technique.
Another way
If you carefully read our article, you probably drew 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 implemented in practice.
In order for you to get the formula in “Excel” (the amount in words will not work without it), you first need to find out where to enter it. Immediately below the toolbar (or under the ribbon in new versions) there is a long field. At its beginning there is an Fx badge, so you won’t be mistaken.
This is where the required functions are introduced. Suppose you need to know the sum of a number of cells that are evenly distributed across a table. First, select the field in which the equation will be calculated. After that, we write “=” in the formula field, and then we prescribe those cells that contain the data you need, separating them with the “+” sign.
For example: = A1 + B2 + C3. When finished typing, press the ubiquitous Enter. The desired number will appear in the field you selected. Since in Excel there is often a need to calculate the amount in this way, you must remember about it.