Calculate in Word Tables
Applies to: Word 2003, Word 2007
Free Word Tips!
Get the WordXpert Newsletter
Sure, you can embed an Excel worksheet in a Word document, but if you just need a few simple calculations, you can use Word's own math skills.
Word 2007
Select the cell at the bottom of a column, go to the Layout tab > Formula.
Word will suggest =SUM(ABOVE), but you can select among over a dozen functions. Besides choosing ABOVE, BELOW, LEFT, or RIGHT to work with all cells in the specified direction, you can reference individual cells and ranges as you do in Excel-for example, =AVERAGE(A1:C3).
For more information, see Word's Help topic, "Field codes: = (Formula) field," for a list of all the functions you can use, the way to express table references, how to precisely format the results with switches and more.
Word 2003
Select a cell at the bottom of a column, go to Table > Formula.
Word will suggest =SUM(ABOVE), but you can select among over a dozen functions.
Besides choosing ABOVE, BELOW, LEFT, or RIGHT to work with all cells in the specified direction, you can reference individual cells and ranges as you do in Excel—for example, =AVERAGE(A1:C3).
