98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Word Training and help » Sums on word
Sums on word
Resolved · Low Priority · Version 2003
RE: Sums on word
Hi Sarah,
Thank you for your post, welcome to the forum, in response to your question; I know you only asked how to create a SUM, but for the sake of others reading this post; I feel that the other formula should be considered as well:
APPLYING FORMULA IN A TABLE
Microsoft Word also allows you to perform calculations in the table by using a mathematical formula. The "Formula" command is used from Table menu to insert a formula into the cell of a table. A formula is an expression that contains any combination of numbers, references of table cells, operators and functions etc. Word inserts the result of the calculation as a field in the cell you selected. The elements of a formula are:
Operators: The basic arithmetic operators that are used in formula are:
"+" used for addition.
"-" used for subtraction.
"*" used for multiplication.
"/" used for division.
"A" used for exponential power.
Functions: The important functions that are used in table cells are:
AVERAGE() Returns the average of a list of values.
MIN() Returns the smallest value in a list.
SUM() Returns the sum of a list of values.
MAX() Returns the largest value in a list.
PRODUCT() Returns the result of multiplication of list of values. For example, the function. = PRODUCT (1, 3, 7, and 9) returns the value 189.
Table Reference:
Table cells are referenced as Al, A2, Bl, B2, and so on, by using the letter representing a column and the number representing a row.
To use cell references in formulas, use a comma to separate references of individual cells and a colon 10 separate the references of first and last cells in a designated range as shown in the following examples.
To calculate average of cells data, the cell reference:, can be written as:
=average (bl: b3) =average (al: b2)
=average (al: c2) =average (al, a3, c2)
You can also use the following references in the function.
LEFT: reference to all cells to the left side of the selected cell.
RIGHT: reference to all cells to the right side of the selected cell.
ABOVE: reference to all cells above the selected cell.
BELOW: reference to all cells below the selected cell.
For example, to calculate the sum of values of all cells above the elected cell, the formula is written as: = SUM(ABOVE)
Similarly, to calculate the average value of values of all cells located to the left side of selected cell, the formula is written as: = AVERAGE(LEFT)
To perform calculations in a table, follow these steps.
Click the cell in which you want to display the result.
On the Table menu click Formula, "Formula" dialog box appears.
From the Paste function box, select a function. For example, SUM function to calculate the sum of numbers.
To use the contents of table cells, type the cell references in the parentheses in the formula. For example, to add the numbers in cells Al and B4, the formula is written as: = SUM (al, b4)
Select other options from the dialog box if required and then click "Ok" button to complete the operation.
I hope that has helped, regards Pete
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Word tip:Changing caseSometimes, you're typing along and don't realize that you have left on or accidently pressed the Caps Lock key. Or maybe you have typed a paragraph in all caps then decide you would prefer to have it in title case or lower case. |