Let’s use a simple calculation in the table of the word

In the chart which was made with Word, making use of well-known SUM () and AVERAGE () function, it is possible with Excel to calculate total and average simply.The complicated calculation like Excel is not possible, but “in the chart which was made with Word just a little calculation became necessary!”Even the time it can correspond sufficiently.

However, numerical value in the chart is modified, copying arithmetic expression, automatic, because Excel and after is a potato, are not calculated, note is necessary at this point in time.

Total will be requested

First, the procedure which calculates total is introduced.It becomes the flow that it calculates total value in one cell, continuously copies arithmetic expression in the other cell, recalculate by hand.

1. Cursor is made the cell which requests total.

2. [Ruled line] -> [arithmetic expression] selecting [arithmetic expression] the dialogue box is opened.

3. [Arithmetic expression] “=SUM (LEFT)” verifies that it has become.”=” Start of arithmetic expression, “SUM ()” totals, “LEFT” has meant the left side.that is, this formula is to sum the left would mean.
4. [OK] click the button.

5.the number of contiguous cells on the left is the total, calculation result is displayed.

6.select the cell has been calculated total.
7. [Ctrl] + [C] press the key. or [edit] [copy] select the. in this, the formula is copied to the clipboard.

8.1place the cursor in the cell directly below, [Shift] + [ ] select the entire cell you want to paste the formula and press the key.
9. [Ctrl] + [V] press the key.

10.formula will be copied. but, at this point, the total value is made to the value of the first cell.
11.while the cell is selected [F9] press the key. this field is updated by.

12.calculation has been performed. let’s clear the selection by clicking the appropriate place.

13.has been calculated that the total can be confirmed.

Excelif you’ve using the, are automatically calculated at the timing and paste the formula, i think you know the correct value to be displayed. unfortunately, Wordthere is no wise until there. the formula is field although it is inserted in a special feature, in order to calculate correctly, after you insert the field field update i need a work called. that’s what we do is, [F9] so the key is.

> try to find the average

try to find the average

let me introduce how to calculate the average then. method of operation is almost the same as total, use a different function. also, you will also need to modify the formula.

1.place the cursor in the cell determine the average.

2. [rule] [formula] select the [formula] open the dialog box.

3. [formula] is =SUM(ABOVE) make sure that you are and. = start of the formula is, SUM() is total, ABOVE since the above is meant, this formula is sum on the would mean. in this way, Wordis, is it attempts to find the sum of contiguous cells or left on anyway. but, from here i want to find is the average, at this rate can not be calculated correctly. you will need to modify the formula so.

4.first, [formula] of = remove the other, leaving only.

5. = in the presence of the cursor to the next [paste function] of [ ] click on the, AVERAGE select the.

6. [formula] to =AVERAGE() will be entered and.

7. =AVERAGE() in parentheses ABOVE enter.
8. [OK] click the button.

9.average value of contiguous cells are lined up on the calculation has been.

10.select the cell average is calculated.
11. [Ctrl] + [C] press the key. or [edit] [copy] select the. in this, the formula is copied to the clipboard.

12.1place the cursor one cell to the right, [Shift] + [ ] select the entire cell you want to paste the formula and press the key.
13. [Ctrl] + [V] press the key.

14.formula will be copied. but, at this point, the mean value is made to the value of the first cell.
15.in the state of a cell is selected [F9] press the key. this will update the field by.

16.calculation has been performed. let’s clear the selection by clicking the appropriate place.

17.average has been calculated.

maximum and minimum values, can also be calculated and the number

what how. if you seek total or average, Wordi understand and be able to handle well in the table. also, [formula] of the dialog box [paste function] in, you can also paste other functions. below, i tried to summarize the main functions.

AVERAGE()……to calculate the average.
COUNT()……count the number of.
MAX()……to calculate the maximum value.
MIN()……to calculate the minimum value.
PRODUCT()……to calculate the product.
SUM()……to calculate the total.

both, in parentheses LEFT or ABOVE typing, to perform the calculations for successive cell on the left and.

but, Wordthe table is to copy the formula or, if you can change the values in the table, Excelplease note that it is not automatically recalculated as. in order to calculate re-, [F9] key calculation in (field) you must manually update the. if you are lazy;, it is useful to remember the following key operation.

[Ctrl] + [A] after pressing the key [F9] key

[Ctrl] + [A] key shortcut key to select the entire document, [F9] key is a shortcut key to update the field of selection. that is, code field in the document are updated, will be up to date all been updated formula.

Incoming search terms:

• =sum(left) word table (1)
• how to get the total of arithmetic expression in excel (1)