sums word

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Word Training and help » Sums on word

Sums on word

resolvedResolved · Low Priority · Version 2003

Sarah has attended:
Word Intermediate course

Sums on word

How do you creae a sum on a word table?

Edited on Mon 7 Jul 2008, 10:27

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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Word tip:

Changing case

Sometimes, 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.

Word provides you with several ways of changing case quickly:

1. You can change case by selecting the text and going to Format-Change Case. You can then choose from a variety of different formats including uppercase, lower case, sentence case, toggle case, and title case.

2. The keyboard can be used to change case. Select the text then use Shift key + F3 (function key) to cycle through the options (lower case, sentence case and all caps).

3. Word has an AutoCorrect feature that corrects accidental use of the caps lock key for you. You can find this feature under Tools-AutoCorrect Options. The "Correct accidental use of the cAPS lOCK key" should be checked.

View all Word hints and tips


Server loaded in 0.08 secs.