Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    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

  2. #2
    Platinum Lounger
    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.

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 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:

    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. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 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.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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