Results 1 to 4 of 4

20041102, 21:58 #1
 Join Date
 Apr 2001
 Posts
 482
 Thanks
 0
 Thanked 0 Times in 0 Posts
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

20041102, 22:15 #2
 Join Date
 Jan 2001
 Posts
 3,788
 Thanks
 0
 Thanked 1 Time in 1 Post
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.

20041102, 22:16 #3
 Join Date
 Feb 2001
 Location
 Silicon Valley, USA
 Posts
 23,112
 Thanks
 5
 Thanked 94 Times in 90 Posts
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:
 <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]

20041102, 22:20 #4
 Join Date
 May 2002
 Location
 Canberra, Australian Capital Territory, Australia
 Posts
 5,201
 Thanks
 2
 Thanked 462 Times in 381 Posts
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.
CheersCheers,
Paul Edstein
[MS MVP  Word]