Calculations in a word table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Latham - 27 Jun 2006 22:15 GMT

I cannot find where to enter and where to update calculations in a word
table. Specifically I want to total specific cells in a row and place it at
the end of that row. Next I want to do the same for columns.

Reply to this Message

Stefan Blom - 28 Jun 2006 09:35 GMT

Use Table | Formula. In the formula you are creating, use Excel-like
notation for referring to individual cells; in other words: A, B, C,
... refers to the columns and 1, 2, 3, ... to the rows.

Note that the Table | Formula command inserts a = (formula) field
which you can insert manually (by pressing Ctrl+F9).

To edit a formula field, just press Alt+F9, change the codes by
typing, press F9 to update, and then press Alt+F9 again to hide field
codes.

Signature

Stefan Blom
Microsoft Word MVP

> I cannot find where to enter and where to update calculations in a word
> table. Specifically I want to total specific cells in a row and place it at
> the end of that row. Next I want to do the same for columns.

Reply to this Message

Stefan Blom - 28 Jun 2006 10:43 GMT

To sum the values in a row, you can use the { = SUM(LEFT) } field in
the cell on the far right. Similarly, to sum the values in a column,
use { = SUM(ABOVE) } in the bottom cell of that column.

To enter the above formulas, type them in the Formula dialog box, or
insert them into the cells directly using Ctrl+F9 to add the field
delimiters, { }.

Use F9 to update fields. If necessary, press Alt+F9 to show/hide field
codes.

Note that cells which are empty may cause trouble with the SUM
function; make sure to type 0 (zero) instead of leaving cells blank.

Signature

Stefan Blom
Microsoft Word MVP

> Use Table | Formula. In the formula you are creating, use Excel-like
> notation for referring to individual cells; in other words: A, B, C,
[quoted text clipped - 12 lines]
> place it at
> > the end of that row. Next I want to do the same for columns.

Reply to this Message

macropod - 28 Jun 2006 12:25 GMT

Hi Latham,

In Word tables, calculations are usually done via formula fields or macros.
Unless you're using a document that's been set up as a protected form,
neither of these approaches delivers the kind of automatic calculations you
can get with applications like Excel.

If you want to see what can be done with formula fields for a wide range of
calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442

Cheers

Signature

macropod
[MVP - Microsoft Word]

Reply to this Message