# How to calculate the amount in the table in Word 2007, 2010, 2013 and 2016

When working with tables in the Word editor, it is often necessary to calculate the amount of elements. For example, in order to determine the number of any objects or get the average value.

In principle, such calculations can be done manually or transfer the table in Excel and calculate everything there, but it will take a lot of time. Using the tools embedded in Word, this task can be solved much faster. In this article we will tell about how to calculate the amount in the table, without leaving the word text editor. The article will be useful for Word 2007, 2010, 2013 and 2016 users.

Suppose you have a Word document with some table, and you want to calculate the sum of numbers in this table. First you need to install the cursor in the table of the table where the amount itself should be directly. In the screenshot at the bottom, this cell is highlighted by an arrow.

After installing the cursor, you need a place, go to the "Layout" tab and click there on the "Formula" button.

As a result, a window appears to insert the formula. There are several fields in this window. The most important field is the Formula field. By default, this field indicates the formula "= SUM (ABOVE)". As you can guess, this formula considers the amount of numbers (SUM - amount) that are located above the selected cell (Above - above, upstairs). If such a formula suits you, then simply click on the "OK" button.

You can also calculate the sum of the numbers that are in another direction relative to the selected cell. To do this, use the following formulas:

• = SUM (above) - the sum of the numbers above the selected cell;
• = SUM (left) - the sum of the numbers located to the left of the selected cell;
• = SUM (Below) - the sum of the numbers located under the selected cell;
• = SUM (RIGHT) - the sum of the numbers located to the right of the selected cell;

If you go on edit the formula, then click on the result of the calculations, so that it will be highlighted with gray, and press the "Formula" button again on the "Layout" tab. After that, a window will open in which it will be possible to change the previously indicated formula.

It should be noted that you can edit your formula as you please. For example, if you need to divide the amount by 2, then we simply add at the end of the formula "/ 2" as in the screenshot below.

The result of using the formula "= SUM (ABOVE) / 2" in the screenshot below.

In addition, you can calculate the amount not only the entire column or rows of the table, but also several separate cells. To do this, specify the address of the cells as it is done in the Excel table processor. Imagine that all columns of your table are numbered using letters (A, B, C, etc.), and all lines with the help of numbers (1, 2, 3, etc.). Using these column numbers and lines in Word, you can create more complex formulas. For example, in the screenshot at the bottom of the formula for counting the sum of the first two cells in the second column.

The result of using this formula in the screenshot below.

In addition to counting the amount in the Word table, other non-complex calculations can be carried out. Below, cod a list of functions that can be used when creating formulas in Word.

 Function Description Example of use ABS () The function to determine the absolute value of the number in brackets. = ABS (-22) And () Function to determine the truth of all arguments. = And (Sum (Left) <10; SUM (above)> = 5) Average () Function to determine the average arithmetic. = Average (Right) Count () Function for counting the number of elements specified in brackets. = COUNT (LEFT) Defined () The function for checking is defined if the argument is defined inside the brackets. = Defined (gross_dy) False Function to return negative value. = False If () Logical function "If". = If (SUM (left)> = 10; 10; 0) Int () Function for rounding to the nearest integer (smaller). = Int (5,67) Max () The function that returns the greatest value among the elements specified in brackets. = MAX (Above) Min () The function returns the smallest value among the elements specified in brackets. = Min (above) Mod () The function returning the remainder from dividing the first argument to the second. = MOD (4; 2) Not () Function for determining truth. If the argument is true, returns a value of 0; If false - 1. = NOT (1 = 1) OR () The logical function "or". = OR (1 = 1; 1 = 5) Product () Function for calculating the product of the elements specified in brackets. = Product (Left) Round () The function for rounding the first element to a number of decimal quantities specified by the second argument. = Round (123,456; 2) = Round (123,456; 0) = Round (123,456; -2) Sign () Function for comparing the specified element with zero (0). If this element is greater than zero, returns a value of 1; If zero is zero - 0; If less zero - -1. = SIGN (-11) SUM () Function for counting the amount in the table. = SUM (RIGHT) True () Function for determining truth. If the argument is true, returns the value 1 if false - 0. is mainly used in the function if. = True (1 = 0)

Please note that position arguments (Left, Right, Above, Bellow) can only be used for the following functions: Average, Count, Max, Min, Product and Sum.

## How in the Word insert the summary formula?

Despite the fact that Microsoft Word is a text editor of the table in it are quite common. And tables, as a rule, consist of numerical values ​​that often need to summarize, output average and so on. In this article, you will learn how in Word 2003 and 2010 count the amounts in the column and stock, as well as how to use tabular formulas in general.

## Counting amounts in the table in Word 2003

Let's start with the classic version of MS WORD 2003. To count the amount of the column in the table, you need to put the cursor in the cell in which the column amount will be. Next choose the menu item "Table" -> "Formula" .

Insert formula in a table in Word 2003

If you need to calculate the amount in the column, then in stock "Formula:" should stand = SUM (ABOVE) .

Column amount formula in Word

Next, simply press "OK" and in the specified cell will automatically be counted the sum of the pillar that is above it.

Table column counting result in Word

Attention! All symbols in the formula are dialing only in capital letters: Above, Left, Right, Summ.

In order to calculate the amount of the line in MS Word 2003, you need to be in the cell, opposite the lines sumparable. Next, perform the whole tighten the team "Table" -> "Formula" and in the opened line formulas write = SUM (Left) .

Formula summons in Word

After that, an automatic counting of the amount of the values ​​of the string located to the left of the specified cell with the amount will occur.

Result counting the sum of the table row in the Word

If the amount is required before the string with the values, then when specifying the formula, its argument Left. , Changing on Right .

Formula summons on the right in the Word

As a result, the formula of the amount of the string with the value of the left of the left line looks like this:

= SUM (RIGHT)

Result counting the amount of the line on the left table in the Word

## Counting the amount in the table in Word 2010

In the Word 2010, counting the amount in rows and pillars of the table is carried out in a similar way, as in Word 2003. The only difference is the location of the button itself "Insert formula" ("Formula") .

In MS Word 2010 it is on the last tab "Layout".

Insert formula in Word 2010

The formulas themselves are similar to Word 2003 formulas.

• Size column = SUM (ABOVE)
• The sum of the values ​​of the left = SUM (Left)
• The sum of the row of values ​​on the right = SUM (RIGHT)

Column counting table column in Word 2010

Now you know how in MS Word 2003 and 2010 count the sum of the poles and rows in the table using formulas.

Greetings, friends! By creating text documents in the Word editor, we can add tables to them. I already wrote about it on the pages of the blog, and many readers asked me as in the Word in the table to calculate the sum of the numerical values. Today we will talk about it.

## Calculation of the amount in the cells of the table

The text processor has the ability to produce simple calculations in tables on special formulas. For example, we take a simple table of counting computing computer equipment in stores. See the drawing below.

Calculate the values ​​for the total and total. Calculate the amount can be using formulas. Click on a table of a table where you need to display the result of the calculation (row of the Total). In the tape tape choose the command Formula which is in the section Working with tables On the tab Layout in a group Data .

The insertion window of the formula will appear, in which the calculation formula will already be spelled out in the "= SUM (ABOVE)" column.

Do not change anything here, just press OK . Numeric data for summation will be taken from the upper cells of the corresponding column. In the target cell, the result of the calculation is displayed, and not the formula.

Attention! The table must be filled with data. . If there is no meaning, then it is necessary to put the number of zero into the cell. Otherwise, the counting will be completed before the first empty cell of the table.

Calculations of the amount in horizontal cells (column of all) is carried out similarly, but the formula must be changed in the dialog box. To count the amount of numbers to the left of the cell with the result, you must write the formula "= SUM (Left)". If the numbers are located on the right - "= SUM (RIGHT)"

To calculate the number of numbers in other destinations, use the table, which is located below.

## Updating the results of calculation by formulas

Unlike spreadsheets, updating the calculated values ​​in Word document occurs when it is open or forcibly. If you changed numbers in the table, you must perform manual update of the following items:

• calculated results of some formulas;
• Results in the selected table.

Update the results for the selected formula Highlight the value calculated previously by the formula you want to update. Press the key F9. .

Updating the results of all formulas in the table Select the entire table containing the results of the formulas you want to update and press the key F9. .

By the way, besides the amount you can calculate Production, average value and number of numerical values . To do this, use the corresponding functions = Product (Left), = Average (Right), = Count (Left). In brackets, the calculation direction is specified as a parameter relative to the cell with the formula. This parameter can be changed, as well as the calculation function of the amount, see the drawing above.

The text processor is primarily intended for writing texts, so if the table requires large amounts of calculations, then you need to use the Microsoft Excel program or similar to it, for example, Calc from the free LibreOffice package.

## How to quickly fold the column

With a large number of columns in which you want to add numbers, you can speed up the sum. To do this, in the depths of the Word, you need to dig up the amount button and add it to the quick access panel. Look at the drawing below. Click on the drop-down list and select Other teams.

In the next window (see below) in the drop-down list (highlighted with a red frame) we choose All teams . And in the lower field, scrolling the list, find item Sum . Zhmem. Add To accommodate this button on the quick access panel. Click OK .

Now calculate the amount in the column or string will be easier than simple. Set the cursor at the bottom of the column under numbers and click Sum . Now it is in the shortcut panel. The result will appear immediately.

When using the button Sum It should be remembered: the priority of calculations is given to the column, not a row. If the numbers are on the left and on top of the resulting cell, then the numbers will be the numbers of the upper cells.

Therefore, to calculate the amount of rows, you need to go to the trick. First summarize in the bottom line, and then go up above.

Hope you use the article. I will be glad to your comments. And also do not forget to share an article with your friends and subscribe to blog updates.

Dear reader! You looked at the article to the end. Did you get the answer to your question? Write in the comments a few words. If the answer was not found, Specify what was looking for or Open Blog content .

Not all Microsoft Word users know that in this program you can calculate according to the specified formulas. Of course, before the capabilities of the office package, the Excel table processor, the text editor does not reach, however, such simple calculations, as the summation of the data, can be performed in it. Today we will tell about how it is done.

## Counting amounts in the Word

Although Microsoft Word is primarily oriented to work with the text, in addition, it can be operated with graphic elements, all kinds of figures and objects, tables and mathematical expressions. The latter "pair" often implies the need to count the amount, that is, it may be necessary to be required both in the table and in the example, formula or equation. In each of these cases, it is necessary to act differently. How exactly will learn later.

### Method 1: Formulas and equations

If in the Word you need to calculate the sum of the numbers or unknown variables recorded in mathematical expression, equation or formula, you will need to refer to the appropriate text editor tool. It is represented in the insertion, creation and change of equations, about working with which we wrote in detail in a separate article on our website - the reference to it is presented below.

Read more: Working with formulas and equations in Microsoft Word

### Method 2: sum in the table

Much more often before users of Microsoft Word arises a slightly more simple task than the creation of mathematical expressions and equations. The need for counting the amount appears when working with tables when it is required to obtain the total value of the numbers recorded in its separate column or row. This is also done with the help of the formula, but completely differently different from the algorithm discussed above.

So, you have a table, in one of the cells of which (probably extreme) you need to withdraw the sum of the numbers recorded in the row or column - with it and we will work. If there is no place for summation, familiarize yourself with one of the following articles below, depending on whether the calculation of which part will be made.

1. Click on the table of the table in which the amount will be output.
2. Go to the tab "Layout" included in the main partition "Working with tables" .
3. In a group "Data" Located in this tab, click on the button "Formula" .
4. In the dialog that opens in the section "Insert a function" Choose "SUM" - This will be the basis for our future formula.
5. Select or specify cells as it can be done in Excel, it will not work in Word. Therefore, the location of the cells you want to summarize will have to be specified differently.

After = SUM. (without any indents) in the string "Formula" Enter one of the following values:

• (ABOVE) - if you need to fold the data from all cells located above formulas;
• (BeLow) - summation of data in the cells located below the one in which the formula fit;
• (Above; Bell) - the sum of the numbers in the cells above and below;
• (Left) - summation of data to the left of the cell;
• (Right) - the amount of numbers to the right of it;
• (Left; Right) - addition of numbers to the left and right of the selected cell.

When specifying the required information for the calculation, click "OK" to close the dialog box "Formula" .

6. The selected cell will indicate the amount of data recorded in the string indicated by you or the column or part.

In addition to the data contained only in the row or column of the table or in the part of this, the Word allows to calculate the sum of the numbers in both of these ranges at the same time, for example, on the left and bottom or on the right and on top of the cell, into which the formula is derived. The syntax is shown in the image below, and under it there is a reference to the Official Microsoft website, where you can learn about other mathematical expressions to work with the tables.

Working with Formulas in Microsoft Word Tables

### Features of the work formula

Making calculations in the table created in Word, you should be aware of several important nuances.

• If you change the contents of the cells included in the formula, the amount of numbers will not be updated automatically. To get a correct result, you must click right mouse button in the cell with the formula and select item "Update the field" .
• Calculations according to the formula are carried out exclusively for cells containing only numeric data. If in the column or line you want to summing up empty cells, the program will output only for that of their part (range), which is located closer to the formula, ignoring the cells, are located above empty. A similar will occur with data with lines.

## Conclusion

As you can see, consider the sum of the numbers in Microsoft Word can be two different methods. The first implies work with mathematical expressions, and the second - with the tables and data contained in their cells.

We are glad that you could help you solve the problem. Describe what you did not work.

Our specialists will try to answer as quickly as possible.

WELL NO

Hello everyone, dear friends and guests of my blog. Today I will tell you how to calculate the amount in the Word in the table with several simple ways. We are accustomed to making such calculations in the Table Editor Excel, but it does not always have a need. Sometimes all manipulations must be done in Word.

## Calculation of the columns in the table

Before proceeding, create a table and fill it with the necessary data.

1. We put the cursor to the last cell of the column where the result should be displayed.
2. Next, in the top menu (tape) select item "Layout" which will automatically appear when we deliver the cursor to the right place.
3. Now, choose the item "Formula" .
4. After that, you will open a window with a function. The field should be written SUM (ABOVE) . This means that the amount of the number will be treated in all values ​​that are above the cell in which we have a cursor. This is necessary for us. Do not change anything and click OK

As you can see, after that you will automatically appear the desired result, which appeared due to the addition of numbers.

It's important to know!  Word does not like empty values, so if a blank cell will be present in the column, you will be mistaken. So either put a value equal to zero, or use the method of calculating the amount from different cells.

## How to calculate the sum of the number numbers

In this case, you will need to do everything the same, that is, choose "Layout"  — "Formula" , Only to start, make sure that the desired values ​​you must count, stand on your left, that is, on one line.

The fact is that Word prefers exactly counting the amounts of cells in the column, therefore, if there are numbers there, then it will suggest to consider them.

But if you can not remove numbers in the column, then manually replace the word in the formula ABove. , on the Left. . This will mean that the amount will be counted according to the values ​​of those cells that are left of you. I hope you are not confused. But if there are no numbers in the column, then the value Left. stand automatically.

You can also use such words as Right и Bellow So that you can count the amount by relying on the values ​​to the right or under the desired cell.

After that, press again OK and enjoy the result obtained.

Also, you may notice that in contrast to Excel, in the Word, the amount of the number is not recalculated if it suddenly changed in one of the cells. We will have to constantly update the value, entering the formula, as we usually do it. But you can do and a little easier. To do this, highlight the result with the amount you want to recalculate, then select "Update the field" . Now the value corresponds to reality.

## How to calculate the sum of different cells in the Word

But it is not always necessary to calculate the amount of a specific column or string. Sometimes it is necessary to calculate the amount in the Word in the table, taking the value from different cells. To do this, make a little different. Here we will have to mentally put the Latin letters over the columns, and before rows the numbers. That is, everything is as in Excele.

Therefore, if I want to calculate the values ​​of the three cells, which I have been highlighted in the screenshot, I should consider that now it is A2, B3 and C1, since mentally, we all flashed.

1. To begin with, I get up as always, wherever we have to be displayed, then we go standard in "Layout"  — "Formula" .
2. Only this time we erase the value that stands in the string completely and in the column "Insert a function" Choose SUM.
3. After that, in the row where it appeared SUM () , We write the coordinates of the cells in brackets. In our case, enter a point with a comma A2; B3; C1 . After that, click OK and that's it.

After that, you will have a result. Well, as we remember, if the value in one of the cells changes, you can simply update the field, highlighting the result and selecting the appropriate item after pressing the right mouse button.

## Insert Excel Tables

Well, you can not bother at all, but simply insert the table into the Word from Excel. Of course, this is not a very convenient way, since you most likely have a formatted table with names, values, and imported from Excel cells will be eased from a common plan. But in them, it is much more convenient to calculate the calculations and calculate the amounts and, in principle, it can be easily adjusted to the document. In general, just in case will leave this method here.

### Calculations

1. Go to the menu "Insert"  — "Table"  — "Excel" . After that, we will automatically get an object from the Table Editor Excel with all rows, columns, as well as marked letters and numbers in vertical and horizontally.
2. Next, we enter the desired parameters and the values ​​that we need, after which we put the sign of equality in the efficient cell.
3. Next, choose the first cell and click on the button "a plus" . Then we allocate the second and press again on "a plus" , and so, until all values ​​are affected.
4. After that we click on ENTER And enjoy the result.

To remove all editing tools, simply click the left button somewhere outside the table.

The undoubted advantage of using the excel tables in the Word is that you will automatically change the results of the calculation, if some of the parameters suddenly change. And you will no longer have to update the fields.

But this method is quite a vigorous, especially if we have many values. Therefore, to calculate the amount in the Word in the table through Excel, it is better to use the insertion of the formula. To do this, do a little differently.

1. Stand up in an efficient cell. Just do not put a sign of equality, and click on the formula icon ( FX. ), which is above the table. After that, in the window that opens, select the value Sum and press OK
2. In a new window, we will be able to insert values ​​in the formula. You can do this manually by writing the coordinates of the values, but I recommend simply allocating all the values ​​that will participate in the calculation of the amount. After that, the range of numbers will automatically be inserted into the formula. It will only be left OK And the result will be displayed where you initially put the cursor.

Of course, you can tell about this stunning function for a long time, but I will not do that, since I have a separate article, where I told in detail how to calculate the amount of cells in Excel. She is very informative, and everything that works there will certainly work here.

### Registration

But all the same, I would like to raise a bit of the design of a table from Excel in Word document, as it differs sharply by display. She is too gray and does not fit into the general plan. Let's try to fix.

Click on the table twice with the left mouse button to re-enter the edit mode. After that, highlight all the numbers and right-click. And then select item "Format cells" .

Now, go to the tab "Borders" And click on two buttons: "Internal" и "External" . In addition, you can choose the type of line and even its color. But personally, I decided to leave the default. Next, Zhmem. OK and clay left mouse button on empty space. This is needed to exit the edit mode.

As we see, now the boundaries we have stylish and black, as it should be. True, there is another bad thing, namely, several empty and unnecessary cells. Simple removal of them not to remove.

To remove an empty place, double-click the table again and you will enter the edit mode. And now, clamp the left mouse button in the bottom corner table, and start pulling it until all unnecessary hits.

After that, we will already be able to observe a full-fledged table without unnecessary elements. By the way, if you have formed empty strings in Excele and need to be removed, I recommend reading my separate article.

Well, finally, you can tell about the sizes of cells. After all, if you want to highlight some headlines, you can make them more. To do this, log in to the editor, clicking on the table twice. After that, move the mouse over the boundaries of the rows or columns until it changes outwardly. After that, clamp the left mouse button on this border and start pulling to expand or narrow the cell.

As you can see, nothing is complicated. Well, I hope that my today's article you liked and helped you. Therefore, I ask you to subscribe to my publics on social networks and notifications from above. Waiting for you again on your blog. Good luck to you. Bye Bye!

Sincerely, Dmitry Kostin

The text editor Microsoft Office Word allows not only to write text, create tables, insert patterns and formulas, but also has a good mathematical apparatus. This feature echoes MS Excel. Using this tool is relevant if the text has many numeric tables with which mathematical operations need to be carried out. This article will reveal the answer to the question of how to calculate the amount in the Word.

Important! Methods for calculating the amount of numbers for all Word versions is identical. Only for WORD 2003, the location of the function is in the menu Table - formulas, and in more recent series of Word 2007, 2010 and 2016 - layout - formula.

In order to calculate the amount in the table, it is necessary to create it already known in the manner and fill in numbers or the necessary data.

## Line

To calculate the amount of the line, you must put the cursor to the desired location of the table, where you need to get the result of the addition, click the Formula button in the Layout section and deliver the value of the function.

By default, the function of the number of numbers located to the left of the cell in which will be the outcome number. The formula tool also allows you to select a number display format or change the function.

To calculate the amount of the values ​​to the right of the cell, you need to change the text of the function with Left to Right in the brackets.

## Column

To calculate the amount of the column, it is necessary to register the value of the ABOVE function, then Word will consider the numbers that are located above the cell.

Important! Values ​​are always written in large letters: Left, Right, Above.

It is also worth noting that the final figures are not recalculated automatically, when the numbers change in the cells. This is a significant drawback and one of the main differences from Excel. However, you can press the right mouse button along the place where the formula is located so that the digit is released and select the update field from the list.

Thus, the following is obtained:

## Function of addition for different cells

Sometimes there is a situation when it is necessary to calculate the value of the amount of several cells that are in different columns and lines. To do this, in brackets of the SUM function to register the addresses of the desired cells. Addressing principle is similar to Excel. That is, the very first cell has an A1 address, the second bottom will be A2, and the second right - B1.

Thus, to fold the selected cells to enter A2; A4; B4; D3. The separator must be a point with a comma.

The disadvantage of this method is that it is necessary to be attentive when assigning the address of the cell, because the error in one place will give an incorrect outcome number.

As you can see, make a simple mathematical operation of addition in Word is not difficult. The text editor allows you to count the number of digits by line, via a column and for various cells, depending on the value of the SUM function.