Add Table Column

D

Don Bouchard

Is it possible to add the numbers in a table column to show the total at the
bottom of the column?
 
M

macropod

Hi Don,

You could insert a SUM(ABOVE) field, but this doesn't work reliably if there are empty cells amongst those that you want to add. The
simplest way to do this is to select the cell where you want the sum to go, press Ctrl-F9 to create an empty field, then type
'=SUM(ABOVE)' between the field braces, thus: {=SUM(ABOVE)}. When you're done, press F9 to update. Do note that, if you change any
values, the result won't update immediately - you'll need to select the field and press F9, or preview or print the document.

Cheers
 
S

Suzanne S. Barnhill

I was afraid of that. In previous versions, it's Table | Formula (grabbing
the default SUM(ABOVE) formula), but in Word 2007 you have to approach it
differently (through Table Tools | Layout | Data | Formula). I believe
another reply to your question provided more details on that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Consolidation Table from Different Excel Tabs with Different Format 1
Autonumber field in Excel that behaves the same as Access 0
List all tables, including document structure 0
Two columns followed by single page-width column on same page 0
Excel does not accept text format! 0
Insert Index into a Table 1
How to insert formula on a fill in form that adds columns 1

Top