Thread: Summing a column of numbers (Word 2000)

1. Summing a column of numbers (Word 2000)

I have tried looking at the Help in word, but still feel rather helpless despite being fairly proficient with Word.

I have a table with a header row. In the last row, I need to put an equation (field or equation editor, whichever works), that will sum all the cells above except for the header row.

How do I do that?

Thanks!!
Troy

2. Re: Summing a column of numbers (Word 2000)

You can use Word fields to achieve this, in this cae {=SUM(ABOVE)}. You can insert it by selecting Insert>Field..., choose =(Formula) from the list of field names and then click on the Formula button and enter =SUM(ABOVE) in the formula box. This will work as long as the header row is not numeric.

<post#=365442>post 365442</post#> contains a useful guide to Word maths.

3. Re: Summing a column of numbers (Word 2000)

You can use an = field with code similar to this:

{ = SUM(B3:B32) # "#,##0.0" }

However, the product help screen entitled "Perform calculations in a table" has an easier way:

1. <LI>Click the cell in which you want the sum to appear.
<LI>On the Table menu, click Formula.
<LI>If the cell you selected is at the bottom of a column of numbers, Microsoft Word proposes the formula =SUM(ABOVE). Click OK if this is correct.

If the cell you selected is at the right end of a row of numbers, Word proposes the formula =SUM(LEFT). Click OK if this is correct. [/P]
Hope this helps.

4. Re: Summing a column of numbers (Word 2000)

Hi Troy,

You could use a formula field like:
{=SUM(ABOVE)-A1}
changing the 'A' to match your coulmn. Be aware, though, that there are some quirks with 'SUM(ABOVE)', as detailed in <post#=365442>post 365442</post#>. The alternative would be to use something like:
{=SUM(A2:An)}
where 'A' indicates the column and 'n' is the last row that you want to sum.

Cheers

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•