Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

enter image description here

share|improve this question

2 Answers 2

up vote 1 down vote accepted

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.

share|improve this answer
    
thanks for the suggestions. I don't follow what is said in #1. When I select the table and then use "Insert>Table" menu I get options to insert, draw, convert text to table, excel spreadsheet, and quick tables but nothing about layouts or formulas –  matt wilkie Nov 23 '11 at 18:27
    
@matt wilkie edited, now it should be more clear :) –  Archibald Nov 25 '11 at 15:50

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.

share|improve this answer
    
When I type this in a cell it just shows me the formula text, not the results,e.g. =100*20 is displayed instead of 2000. –  matt wilkie Nov 23 '11 at 18:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.