How to calculate the sum of a line in Word. Microsoft Word

Let's consider how to insert a formula in a Word table. Can be installed mathematical formulas in Word, who will count. Can insert formulas into Word text. About creating formulas in Word text How to write an equation, read the article “Formulas in Word”.
Word can do the calculations. To do this, you need to write a formula in a table cell.If you change numbers in a Word table, the formula itself does not automatically recalculate the result. In order for the formula to recalculate the result, you need to select the cells with formulas, the entire column, row or entire table, and press the "F9" key.
Or, select not the entire cell with the formula, but the number (the result of the formula). Click right mouse to the selected number. From the window that appears, select the “Update field” function.
For more complex calculations and automatic data recalculation, you need to insert Excel spreadsheet. See How to Make a Table in Word.
So, mathematical formulas in Word.
Amount icon in Word.
To add numbers in a column or row in a Word table quickly, you need to place on the panel quick access Amount icon (∑).How to do this, see the article “What can you do in Microsoft Word » .
It turned out like this.
Now, to count the numbers in a column, set the “Sum” icon at the bottom of this column in the cell in which the result should appear (in the example, the yellow cell). All numbers above this icon are automatically counted.
To count the numbers in a line, place the sum icon in the outermost cell of the line (in the example, the green cell).
Creating Formulas in Word.
Cells in a Word table have the same addresses as in an Excel table.The Excel table can be viewed in the article “How to open Excel sheet(create on desktop)» . This is an example of Word table cell addresses.
There is a table in which we will set up formulas and count numbers.
Sum formula in Word.
The yellow cell will contain the result of the addition - place the cursor in this cell. The “Working with tables” tab has appeared on the quick access panel (at the top). Go to the “Layout” section and select the “Formula” function (the button is circled in red).

Click on this button and the following dialog box will appear.We will write all formulas in this window.
The formula for the amount has already been written here. Word sees that in our table the numbers are in only one column, it will count them.
The formula is written in brackets (ABOVE) - this means that all cells will be counted column, located above the cell in which we set the formula.
Other notations in the formula:
(BELOV) – cells will be counted column, located below the cell with the formula.
(LEFT) – cells will be counted in line, located to the left of the cell with the formula.
(RIGHT) – cells will be counted in line, located to the right of the cell with the formula.
You need to write these words if we do not indicate a specific cell address in the formula.
If we put a formula in a cell in the middle of the table, then the formula must indicate which side to count from.
So, the addition formula turned out like this.
Subtraction formula in Word.
Place the cursor in the blue cell.We call up the “Formula” dialog box, but change the addition formula to our own.
We leave the “equals” sign, delete the word “SUM”, delete the word (ABOVE) in parentheses and write the subtraction formula according to the same principle as in Excel, using cell addresses. The result is the following formula. Multiplication formula in Word.
Place the cursor in the green cell. We write the formula in the “Formula” dialog box. The result is the following formula. Division formula in Word.
Place the cursor in the pink cell. We write the formula in the “Formula” dialog box. It turned out like this. How to write a complex formula in Word.
Set the following formula in the blue cell.
We have a table like this.
You can insert the address of a range of cells, etc., into a formula; in Word this is called a "bookmark". It will help you insert a cell, a range of cells from another table, etc. into the formula. How to create and insert a bookmark into a formula, see the article "How to insert into mathematical formula in Word bookmark".
How to write other formulas in a Word table, how to subtract percentages, find the arithmetic mean, how to combine functions in a Word formula, etc., see the article "Creating formulas in Word".
Where to find arithmetic signs on a PC keyboard, see “Where is the button on the keyboard.”
How to convert text into a table or text from a table, see the article “Convert a Word table into text and vice versa.”

It's rare when you have to Microsoft program Word calculate the amount, since it is more convenient to do this in Excel, but still, if necessary, you must first go from the main menu to the section called Market, then you need to select the Formula tab, and then enter =SUM(ABOVE), that’s all, then click OK, the amount will be calculated.

Then enter into the table numeric values, working in Constructor. Then you need to select the next item - Layout. And in last section Data select Formula. In this case, the mouse cursor must be in the correct place. If you need to calculate the amount in a column, then the cursor should be on the bottom line. In this case, you don’t need to write a formula, it will appear on its own, all you have to do is click OK. The resulting number can only be deleted, it cannot be edited.



It is best, of course, to use Excel for calculations, but you can also do this in Word.

Calculating the amount in Word is quite simple. To do this, place the cursor in the table cell where we will have the estimated amount. Now go to the tab called LAYOUT, then select the formula and write =SUM(ABOVE) there. Perhaps this value is already there, now press the OK button

Very often you have to create tables not in Excel, but in Word, and I was interested (and even needed!) to find out - how can you calculate the amount in Word? It turns out that this is not so difficult to do:



• Once upon a time, when working in the first versions word processors, this question would have no answer. Then there was a clear division of labor: texts - in text editor, tables and calculations - in tabular.

  But time goes by software products are developing and everything more features borrow from each other, so simple calculations can be done in Word (and in free analogues from Libre/OpenOffice too).

  Just enter the formula =SUM(....) into the desired cell, where it is not necessary to put ABOVE in parentheses (which means ABOVE, sum the cells that are located ABOVE), you can (if necessary) instead of ABOVE enter LEFT, RIGHT, or BELOW ( to sum all cells on the left, right, or those below).

  In Windows 10, you can now calculate the amount in Word documents if necessary, which could not be done in earlier versions.

  So, we place the cursor in the desired cell of our table and select the Layout tab, in it we find the formula icon and click on it. In the window that appears, select =SUM(ABOVE) or enter it manually.

  Usually, at work, I always create all the tables in Excel. since it is very convenient to calculate using formulas. And it was a discovery for me that the autosum can be calculated in Word program. And this is done like this: we create a table and enter all the data, put the cursor in the cell you need, where you need to calculate the amount, even go to the tab called LAYOUT, put the formula there and type SUM(ABOVE) and click on OK. That's all, the amount will be calculated automatically.

  Via Microsoft Word amount It is calculated very simply.

  We click on the empty field of the table where, in theory, the amount should appear.

  Next we look at top panel(settings menu) Word, where in the Working with Tables section on the right is the Market tab. Click on it, and then on the Formula button in the Data section. A window will open, you just need to click on OK and that’s it.

Calculation using given formulas is possible not only in the Excel spreadsheet processor, but also in the text processor Word editor. It’s interesting that many even quite experienced users have no idea about this.

True, the capabilities of this application in such calculations are very limited, but something can still be done. As a rule, small tables intended for insertion into text are formed directly in Word, while large tables with many numbers are more convenient to process in.

As an example, let’s take a small table of how a team of students performed olympiad tasks in any subject. The table shows: the total number of tasks per person, the number of tasks completed and the percentage of tasks completed correctly.

No.	Full name	Number of tasks	Number of completed tasks, units.	Proportion of tasks completed correctly, %	Points
1.	Ivanov I.I.	10	10	90	90
2.	Petrov P.P.	10	10	85	85
3.	Vasiliev V.V.	10	9	80	80
4.	Kharlamov I.N.	10	8	60	60
5.	Stogov B.B.	10	10	85	85
	Total	10	9,4	80	400

Inserting a formula

To get an overall picture of the team’s performance, the bottom line “Total” shows the average values ​​for the first three indicators and the sum of points earned by the team. For automatic filling To complete the final row, you need to place the cursor in the final cell, and the “Layout” tab, designed for working with tables, will appear and open. Inserting formulas for table calculations

In this tab you need to click on virtual button“Data”, and then “Formulas”, this will open the window for inserting formulas. As you can see, there is enough a large number of available functions. Our table only needs the sum (SUM) and the arithmetic average (AVERAGE). The parentheses indicate the location of the numbers being added, for example ABOVE means that the numbers are located above the resulting cell.

In our table, all data is located above the cell, so to find the arithmetic mean, insert , and to find the sum of the numbers above.

Data Update

In Word, calculation results are not automatically updated when cell contents change, so you have to get a new result manually. To do this, click on the formula right click mouse and select "Update Field".

Update summary field

When making calculations in tables compiled in Word, you need to remember that calculations using formulas are performed only for non-empty cells. Moreover, in calculations using the formula, only values ​​located closer to the formula are taken into account. Data from other cells separated by an empty cell are not taken into account.

Thus, we learned to find the arithmetic mean and the sum of the numbers located in our simple table. In the same way, you can make calculations using other formulas.

Hello, friends! After reading today's Cheat Sheet, you will be convinced that the calculations in WORD tables- a fairly simple matter. We will learn how to perform all arithmetic operations with digital data from Word tables, find the average, and calculate percentages. We won’t deal with higher mathematics (I promise): and we’ll send those who need integrals, derivatives, or (forgive me, lords) extrema of functions straight to Excel.

But before we proceed directly to the calculations, let's remember how it is customary to set cell addresses in tables. In Fig. Figure 1 shows a table with numbered rows and labeled columns.

(pictures are clickable)

To make it clear, I quote the addresses of the numbers in it:

• A5 - 12;
• B2 - 34;
• C3 - 47;
• D6 - 61.

Moreover, it is not at all necessary to put letter designations for columns or number rows directly in the table itself: such addressing is implied by default. Now you can proceed directly to the calculations. And we will start with the most common case.

How to add numbers of a column or row in a Word table

We perform all mathematical operations with numbers in Word tables from the panel "Working with tables", which opens by left-clicking in the table field or on the movement marker (cross in the upper left). Next, go to the tab "Layout", chapter "Data", button "formula"(see Fig. 2).

In order to add the numbers of one line, you need to place the cursor in its last cell intended for the sum and click in the drop-down dialog box "Formula" by button "OK". So it's simple? IN in this case, Yes. The fact is that by default the text editor offers to calculate exactly the sum, and the location of the cursor in the last cell will explain to the smart program that all the numbers in this line need to be added (Fig. 3).

Of course, if you need to add not all the numbers in a row, but only from several columns, then this problem can be solved. Then simply place the cursor in the column after the numbers to be summed. Please, friends, pay attention to the entry in top line window "Formula": = SUM(LEFT)- this inscription just means: the sum of the numbers to the left of the cursor. In the same way, the program can calculate for us the sum of the numbers to the right of the cursor - = SUM(RIGHT).

I would like to draw your attention, dear readers, that despite his fairly developed intellect, Word does not tolerate emptiness, that is, he perceives an unfilled cell as an error. This means that in all empty cells you will need to put zeros.

In a similar way, you can sum the numbers in a row by placing the cursor in its lower cell. In this case, the entry in the line "formula" the window of the same name will look like this: = SUM(ABOVE)(see Fig. 3), which means the sum of the numbers in the cells located above. Accordingly, if you need to add numbers from the cells below the cursor, enter: = SUM(BELOW).

Words - LEFT(left), RIGHT(on right), ABOVE(above), BELOW(sub) - called positional arguments. They are convenient to use for operations in rows and columns, and Word does not take into account the numbers in the heading line.

So, friends, we have discussed with you the simplest and most frequently used version of calculations in Word tables, when the program runs “automatically”. In all other cases, you will have to select a formula and enter the initial data for each pair of cells. Now I will explain to you how this is done.

How to multiply, divide or subtract numbers in a WORD table

To perform these actions, the easiest way is to use arithmetic operators: * - multiplication; / - division; - - subtraction. Here are examples of entries that can be entered in a line "formula":

• addition - =A1+B2;
• multiplication - =A5*B5;
• division - =B4/B1;
• subtraction - =A6-B6.

Please note that every formula begins with an equal sign (=). And then, without any spaces, enter the cell addresses and arithmetic signs.

For multiplication, the program provides another option - PRODUCT. This is a multiplication function, just like SUM- addition. In this case, cell addresses must be entered in parentheses separated by semicolons (see Fig. 4).If we're talking about about finding the product of a column or row, then you can not list all the cells, but specify them using an interval separated by a colon, for example: = PRODUCT(A1:A8).

And now, friends, a little about the sad. You must have already realized that tables in Word are suitable only for simple calculations; the range of possible operations is small. Moreover, in the above examples of arithmetic operations, changing one or both arguments (values ​​in cells) will not automatically change the result. To get a new value, you will need to select the old one and press the key F9 or by right-clicking on the highlighted number and selecting the line in the pop-up window "update field".

Among other mathematical functions for calculations in tables in Word, the following are available:

• arithmetic average in the range: = AVERAGE();
• determination of the maximum and minimum values in the specified cells: = MAX/MIN();
• remainder of the division: =MOD();
• selecting the integer part of a number: = INT();
• rounding to the indicated digit: = ROUND().

We will not discuss the remaining functions - statistical and logical - within the scope of this article. What we have left of what was promised is interest and the arithmetic average. So let's take care of them.

How to calculate the arithmetic mean in a WORD table and calculate percentages

1. To calculate the arithmetic mean in a row or column, place the cursor in their last cell and open the window "Formula" ("Working with tables"- tab "Layout"- chapter "Data"- button "Formula"). In the top line of the window, enter the required formula: = AVERAGE(A1:A7) and in the last (eighth) cell of the first column we get the result (see Fig. 5).

1. To calculate percentages in a window "Formula" we will have to write: =[address of the cell with the number from which we will calculate the percentage]/100*[percentage]. Let's say we want to take 3% of 300. Enter: =A3/100*3 or even simpler: =A3*0.03. The result, of course, is 9. But I deliberately took prime numbers, the result of the operation with which is easy to check in my head. You, friends, having grasped the principle of this procedure, can now operate with any values.

To repeat and consolidate the material covered, I suggest watching a short video.

I hope after watching the video the calculations in the tables WORD more do not pose any difficulties for you.

Goodbye friends. Your guide to WORD 2016 copywriter GALANT.

Haven't you read these articles yet? In vain... This is also about tables:

As I have said more than once: although Word and Excel are similar in appearance, each of them prefers not to creep into the territory of their “brother”. For example, in Excel, and in Word - with tables. However, as practice shows, it is possible to overcome both, the only question is - at what cost will this be done :).

Another thing is that some functions of the table editor, at first glance, are completely unavailable in the editor text document. For example: using formulas in MS Word, arithmetic operations, etc. tasks. But is it really so? Of course not, protozoa mathematical operations in MS Word(although not all) are available at any time and are just waiting for the opportunity until you are ready to put them into practice. Let's make sure of this?

Autosum and other mathematical operations in MS Word

So, I have a simple table created in MS Word (by the way, I created it). All you need to do is fill in the last column, and not just anyhow, but automatically: by multiplying the data in the “Price” and “Quantity” columns.

The most common table created in MS Word

But we choose a different path: we place the mouse cursor in the first cell desired column, And on the Layout tab, in the "Data" group, select Formula tool.

Displayed on screen Formula window and this is where the fun begins.

Window for creating formulas for Word

We are interested in "Formula" field, where by default it contains something like " =SUM(LEFT)". Without further explanation, it is clear that this formula sums and does not multiply. We erase everything except the equal sign, and below, in the “Insert function” drop-down list, select PRODUCT(). Enter the word LEFT in brackets and click “OK”.

As soon as the settings window disappears, the calculation result immediately appears in the table cell. And... to be honest, this is where all the clarity ends. How does this thing work? Yes, we can’t do without additional explanations here.

How to use mathematical operations (functions) in MS Word

The basic principle of the formulas is simple: first (after the = sign) it is indicated WHAT needs to be done, that is, the type of operation, and then in parentheses, it is indicated WHAT the operation needs to be performed WITH, that is, the range.

Basic types of arithmetic operations in MS Word:

• AVERAGE()- average
• PRODUCT()- multiplication
• SUM()- sum
• MIN()- minimum value
• MAX()— maximum value
• COUNT()— value counter

Options for specifying a data range for calculations in MS Word:

• LEFT
• RIGHT— take everything to the left of the current cell (in a row)
• ABOVE- everything is on top of the cell (in a column)
• BELOW- everything below the cell (in a column)

In this case, range indicators can be combined: =SUM(LEFT RIGHT) - add everything to the left and right of the cell. In addition, you can enter data from the keyboard: =SUM(10;15) - add 10 and 15 (do not forget about the semicolon separator).

Well, is it difficult? This is just the beginning. Although, it seems you still have a number of questions.

For example, you probably noticed that there is no subtraction or division in the list of functions. And yes, you really didn’t think so. Of course this is a minus, but don’t forget - we work in a text editor! In addition, addition and multiplication operations are used more often in everyday life - just look at my table.

Nobody suggests (especially Microsoft!) that you will do all the calculations in Word, but partial implementation of the functions discussed above greatly simplifies a number of operations:

• Allows you to always have a “calculator” at hand for quick data calculation (=SUMM(256;2.3))
• Allows you to round numbers and find averages =INT(2.3) will output "2".
• It is successfully used for the final summation of data in a column or row of a table (=SUMM(ABOVE) in the lowest cell).