bottom
Great WordTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > WordTips Home > Tables > Summing a Table Column

Summing a Table Column

Summary: Need to add a sum to a column of figures in a table? Word makes it relatively easy to provide the sum you need. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

Word allows you to do simple spreadsheet-style calculations on tabular data. You do this using equation fields. For instance, let's assume you had a 20-row table in which you wanted to total the values in the third column. All you need to do is the following if you are using a version of Word prior to Word 2007:

  1. Position the insertion point in the cell you want to contain the total. (In this example, you would position the insertion point in the bottom cell of the third column.)
  2. Choose Formula from the Table menu. Word displays the Formula dialog box. (Click here to see a related figure.) Notice that a suggested formula is already filled in the Formula box.
  3. Using the Number Format drop-down list, select how you want the number to be formatted. (This step is optional.)
  4. Click on OK.

At this point Word places the sum of your column in the cell. If you have the Tables and Borders toolbar visible on your screen (available in versions of Word prior to Word 2007) there is an easier way to sum a table column. Follow these two steps:

  1. Position the insertion point in the cell you want to contain the total. Typically, this is the bottom cell in a column of numbers.
  2. Click on the AutoSum tool on the Tables and Borders toolbar.

If you are using Word 2007, then you can insert the sum for the table column in this manner:

  1. Position the insertion point in the cell you want to contain the total. Typically, this is the bottom cell in a column of numbers.
  2. Click the Layout tab on the ribbon.
  3. Click the Formula tab in the Data group. Word displays the Formula dialog box.
  4. Using the Number Format drop-down list, select how you want the number to be formatted. (This step is optional.)
  5. Click on OK.

Once the sum is placed in the cell (whichever method you follow to place it there), and you later change the column figures, remove rows, or add new rows, you will need to update the sum. You do this by selecting the field you inserted and then pressing F9.

Tip #58 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007


Find and Replace Almost Anything! An invaluable resource for learning how to harness the full power of Word's search and replace capabilities. You'll discover everything you need in order to master all the intricacies of finding and replacing elements of your document, including the super-powerful "wildcard searches" available in Word.
 
Check out WordTips: Find and Replace today!

Helpful Links

Ask a Word Question
Make a Comment

Tips.Net Home
Tips.Net Store

WordTips FAQ
WordTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
WordTips Site

 

Great Info!

Get tips like this every week in WordTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)