How do I insert auto sum in a Word 2007 table?

Discussion in 'Word Tables' started by Jackie, May 8, 2008.

  1. Jackie

    Jackie Guest

    In older versions of Word, I was able to add (sum) a simple column of numbers
    by inserting a formula rather than using Excel. This was especially useful
    when preparing a letter or other document.
     
    Jackie, May 8, 2008
    #1
    1. Advertisements

  2. It's a little more involved in Word 2007. With the table selected, select
    the Layout tab of the Table Tools and click on Formula. If you have values
    in the cells above, then SUM(ABOVE) will be offered as the default formula.
    Otherwise you have to choose a function and type in cell references.

    The same is true of the Sum button, which you can add to the QAT (it's in
    the All Commands section Word Options | Customize).


    --
    Suzanne S. Barnhill
    Microsoft MVP (Word)
    Words into Type
    Fairhope, Alabama USA

    "Jackie" <> wrote in message
    news:D...
    > In older versions of Word, I was able to add (sum) a simple column of
    > numbers
    > by inserting a formula rather than using Excel. This was especially
    > useful
    > when preparing a letter or other document.
    >
     
    Suzanne S. Barnhill, May 8, 2008
    #2
    1. Advertisements

  3. Jackie

    Guest

    Thanks A lot for this solution :)

    On Thursday, May 8, 2008 8:46:01 PM UTC+6, Jackie wrote:
    > In older versions of Word, I was able to add (sum) a simple column of numbers
    > by inserting a formula rather than using Excel. This was especially useful
    > when preparing a letter or other document.


    ..
     
    , Jul 27, 2012
    #3
  4. Jackie

    Guest

    in windows 2007, u can sum the values in a col/row by using summation(E)function. this function will not be available in default. u have to insert it.click "customize the quick accsss toolbar" in top left corner. then select"more commands" u will get a new pop up window. select customize menu and choose "all commands" select sum from the drop down and add it to ur customize quick access toolbar. the symbol will inserted in ur word document.
     
    , Aug 11, 2013
    #4
  5. Jackie

    Stefan Blom Guest

    For more on formulas in Word, see
    http://office.microsoft.com/en-us/w...or-row-of-numbers-in-a-table-HA102809672.aspx
    (Sum a column or row of numbers in a table).

    Note that it's usually faster to insert the field code directly. Just press
    Ctrl+F9; Word inserts field delimiters, { }, and you can then type in the
    instructions.

    --
    Stefan Blom
    Microsoft Word MVP




    <> wrote in message
    news:...
    > in windows 2007, u can sum the values in a col/row by using
    > summation(E)function. this function will not be available in default. u
    > have to insert it. click "customize the quick accsss toolbar" in top left
    > corner. then select "more commands" u will get a new pop up window. select
    > customize menu and choose "all commands" select sum from the drop down and
    > add it to ur customize quick access toolbar. the symbol will inserted in
    > ur word document.
     
    Stefan Blom, Aug 11, 2013
    #5
  6. Jackie

    Guest

    On Thursday, May 8, 2008 11:16:50 AM UTC-5, Suzanne S. Barnhill wrote:
    > It's a little more involved in Word 2007. With the table selected, select
    > the Layout tab of the Table Tools and click on Formula. If you have values
    > in the cells above, then SUM(ABOVE) will be offered as the default formula.
    > Otherwise you have to choose a function and type in cell references.
    >
    > The same is true of the Sum button, which you can add to the QAT (it's in
    > the All Commands section Word Options | Customize).
    >
    >
    > --
    > Suzanne S. Barnhill
    > Microsoft MVP (Word)
    > Words into Type
    > Fairhope, Alabama USA
    >
    > "Jackie" <> wrote in message
    > news:D...
    > > In older versions of Word, I was able to add (sum) a simple column of
    > > numbers
    > > by inserting a formula rather than using Excel. This was especially
    > > useful
    > > when preparing a letter or other document.
    > >


    Thank you! This is the first explanation that worked for me, & I've been trying to figure it out for 2 hours.
     
    , Oct 17, 2013
    #6
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    0
    Views:
    286
  2. amy
    Replies:
    1
    Views:
    100
  3. hik_hk
    Replies:
    2
    Views:
    71
    challa prabhu
    Jan 30, 2007
  4. NCC

    sum(above) Bug in Word 2007 Table

    NCC, Apr 5, 2007, in forum: Word Tables
    Replies:
    1
    Views:
    131
    Herb Tyson [MVP]
    Apr 5, 2007
  5. Rick@#$*!
    Replies:
    10
    Views:
    237
    Graham Mayor
    May 17, 2010
  6. mroqueta
    Replies:
    5
    Views:
    188
    Suzanne S. Barnhill
    Oct 27, 2008
  7. Schuuch
    Replies:
    1
    Views:
    86
    Doug Robbins - Word MVP
    May 20, 2009
  8. Dax Arroway

    Auto Calculate SUM formula in Table

    Dax Arroway, Mar 12, 2010, in forum: Word Tables
    Replies:
    4
    Views:
    335
    Stefan Blom
    Mar 15, 2010
Loading...