Calculate numbers in MS Word table

Question

Is there any way to have MS Word do simple calculations on numbers in a table without going through the rigamarole of copying the table to Excel, doing calcs, and then copying back again? All I need to do is things like "SUM {this column}" and "PRODUCT {this row}". I wouldn't mind doing roundtripping through Excel so much, except that the formatting always gets really messed up and it's too much work to fix that repetitively.

Converting the docs to Excel is not an option as these are from outside our office. I'm using Word 2010.

Answer 1

Office 2007 professional:

Solution 1:

Insert->Table,

when table is created select cell where you need to add formula

then go to Layout->data->formula

dialog box should appear where you might write your formula or choose one from Paste function combobox.

row/column ranges description is similar to excel (column as letters, rows as numbers)

For example sum of first four cells in first column:

=SUM(a1:a4)

With this solution you need to update formula manually (to update whole table: select table and press F9)

Solution 2:

Insert->Table->Excel Spreadsheet

Hope this helps.

Answer 2

Edited...

Take a look at: microsoft and some other site

You're right, in Word 2010 you should do that using the menus. See the "layout" tab, after you click inside your table, in any cell? In the "data" section, there's one button labeled "formula". Click it and insert your formula

In the middle of this page you'll find how to do it.