How do I sum a column in a table in Word 2007?

Rick · External Since: Jul 09, 2007 Posts: 1

How do I sum a column in a table in Word 2007? New-fangled version is toooo
complicated....

Summer · External Since: Jun 03, 2007 Posts: 211

If you have a column row with figures tab to next row and move to column you
wish to Sum (there should already be at least one amount say "10" in the Sum
column.

Press Insert Layout Formula (end of ribbon) {= SUM(ABOVE } will appear Press
ALT F9 to toggle this code view.

Hope this helps.

"Rick@#$*!" <Rick@#$*!@discussions.microsoft.com> wrote in message
news:4CC3BC9E-2AAC-4C6D-A2C2-171E48453273@microsoft.com...
> How do I sum a column in a table in Word 2007? New-fangled version is
> toooo
> complicated....

Graham Mayor · External Since: Jul 04, 2006 Posts: 4677

Or with the cursor in the cell where you want the calculation, Insert >
Quick Parts > Field > = (Formula field) and again =Sum(Above) will be the
default.
Note that with 'Summer's' method, the cursor has to be in the table for the
layout tab to appear on the ribbon.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Summer wrote:
> If you have a column row with figures tab to next row and move to
> column you wish to Sum (there should already be at least one amount
> say "10" in the Sum column.
>
> Press Insert Layout Formula (end of ribbon) {= SUM(ABOVE } will
> appear Press ALT F9 to toggle this code view.
>
> Hope this helps.
>
> "Rick@#$*!" <Rick@#$*!@discussions.microsoft.com> wrote in message
> news:4CC3BC9E-2AAC-4C6D-A2C2-171E48453273@microsoft.com...
>> How do I sum a column in a table in Word 2007? New-fangled version is
>> toooo
>> complicated....

Rick · External Since: Jul 10, 2007 Posts: 1

Thanks Summer and Rick both helpful replies.

"Graham Mayor" wrote:

> Or with the cursor in the cell where you want the calculation, Insert >
> Quick Parts > Field > = (Formula field) and again =Sum(Above) will be the
> default.
> Note that with 'Summer's' method, the cursor has to be in the table for the
> layout tab to appear on the ribbon.
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> Summer wrote:
> > If you have a column row with figures tab to next row and move to
> > column you wish to Sum (there should already be at least one amount
> > say "10" in the Sum column.
> >
> > Press Insert Layout Formula (end of ribbon) {= SUM(ABOVE } will
> > appear Press ALT F9 to toggle this code view.
> >
> > Hope this helps.
> >
> > "Rick@#$*!" <Rick@#$*!@discussions.microsoft.com> wrote in message
> > news:4CC3BC9E-2AAC-4C6D-A2C2-171E48453273@microsoft.com...
> >> How do I sum a column in a table in Word 2007? New-fangled version is
> >> toooo
> >> complicated....
>
>
>

Graham Mayor · External Since: Jul 04, 2006 Posts: 4677

I thought you were Rick? Wink

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Rick@#$*! wrote:
> Thanks Summer and Rick both helpful replies.
>
> "Graham Mayor" wrote:
>
>> Or with the cursor in the cell where you want the calculation,
>> Insert > Quick Parts > Field > = (Formula field) and again
>> =Sum(Above) will be the default.
>> Note that with 'Summer's' method, the cursor has to be in the table
>> for the layout tab to appear on the ribbon.
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>>
>> Summer wrote:
>>> If you have a column row with figures tab to next row and move to
>>> column you wish to Sum (there should already be at least one amount
>>> say "10" in the Sum column.
>>>
>>> Press Insert Layout Formula (end of ribbon) {= SUM(ABOVE } will
>>> appear Press ALT F9 to toggle this code view.
>>>
>>> Hope this helps.
>>>
>>> "Rick@#$*!" <Rick@#$*!@discussions.microsoft.com> wrote in message
>>> news:4CC3BC9E-2AAC-4C6D-A2C2-171E48453273@microsoft.com...
>>>> How do I sum a column in a table in Word 2007? New-fangled version
>>>> is toooo
>>>> complicated....

P.O.'d with Microsoft · External Since: Jun 12, 2009 Posts: 1

I still can't get it to work!!! I loved Wordperfect, but gave it up with my
new Vista PC because I had to replace almost ALL my software- at great
expense (but that's another matter). What I CAN'T BELIEVE is that Microsoft
has decided that summing a column in Word is not one of the most normal and
NECESSARY functions. I KNOW that I could remake my invoices to use Excell
instead - but WHY SHOULD I HAVE TO?? It is enough to make me decide to
discard MS Office altogether. I was happier with WordPerfect and Quattrro!!
and if all the $!%$@! thing needs is ONE SUM, why should I convert it? Even
the latest AutoCAD software has annoying features (or lack of them) in Vista.

"Rick@#$*!" wrote:

> Thanks Summer and Rick both helpful replies.
>
> "Graham Mayor" wrote:
>
> > Or with the cursor in the cell where you want the calculation, Insert >
> > Quick Parts > Field > = (Formula field) and again =Sum(Above) will be the
> > default.
> > Note that with 'Summer's' method, the cursor has to be in the table for the
> > layout tab to appear on the ribbon.
> >
> > --
> > <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> > Graham Mayor - Word MVP
> >
> > My web site www.gmayor.com
> > Word MVP web site http://word.mvps.org
> > <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >
> >
> > Summer wrote:
> > > If you have a column row with figures tab to next row and move to
> > > column you wish to Sum (there should already be at least one amount
> > > say "10" in the Sum column.
> > >
> > > Press Insert Layout Formula (end of ribbon) {= SUM(ABOVE } will
> > > appear Press ALT F9 to toggle this code view.
> > >
> > > Hope this helps.
> > >
> > > "Rick@#$*!" <Rick@#$*!@discussions.microsoft.com> wrote in message
> > > news:4CC3BC9E-2AAC-4C6D-A2C2-171E48453273@microsoft.com...
> > >> How do I sum a column in a table in Word 2007? New-fangled version is
> > >> toooo
> > >> complicated....
> >
> >
> >

macropod · External Since: Jan 10, 2009 Posts: 105

Hi,

With the table cell where you want the sum to appear selected, click on the table 'Layout' Ribbon tab, then click the formula icon
and type in your forumla (eg =SUM(ABOVE) or =SUM(A1:A5), or whatever else it is you need) and add the appropriate numeric formatting
switch from the dropdown. Not at all difficult, really.

--
Cheers
macropod
[Microsoft MVP - Word]

"P.O.'d with Microsoft" <P.O.'d with Microsoft RemoveThis @discussions.microsoft.com> wrote in message
news:1771BB3C-3264-4D82-963F-336BF4FDEA91@microsoft.com...
>I still can't get it to work!!! I loved Wordperfect, but gave it up with my
> new Vista PC because I had to replace almost ALL my software- at great
> expense (but that's another matter). What I CAN'T BELIEVE is that Microsoft
> has decided that summing a column in Word is not one of the most normal and
> NECESSARY functions. I KNOW that I could remake my invoices to use Excell
> instead - but WHY SHOULD I HAVE TO?? It is enough to make me decide to
> discard MS Office altogether. I was happier with WordPerfect and Quattrro!!
> and if all the $!%$@! thing needs is ONE SUM, why should I convert it? Even
> the latest AutoCAD software has annoying features (or lack of them) in Vista.
>
> "Rick@#$*!" wrote:
>
>> Thanks Summer and Rick both helpful replies.
>>
>> "Graham Mayor" wrote:
>>
>> > Or with the cursor in the cell where you want the calculation, Insert >
>> > Quick Parts > Field > = (Formula field) and again =Sum(Above) will be the
>> > default.
>> > Note that with 'Summer's' method, the cursor has to be in the table for the
>> > layout tab to appear on the ribbon.
>> >
>> > --
>> > <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> > Graham Mayor - Word MVP
>> >
>> > My web site www.gmayor.com
>> > Word MVP web site http://word.mvps.org
>> > <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> >
>> >
>> > Summer wrote:
>> > > If you have a column row with figures tab to next row and move to
>> > > column you wish to Sum (there should already be at least one amount
>> > > say "10" in the Sum column.
>> > >
>> > > Press Insert Layout Formula (end of ribbon) {= SUM(ABOVE } will
>> > > appear Press ALT F9 to toggle this code view.
>> > >
>> > > Hope this helps.
>> > >
>> > > "Rick@#$*!" <Rick@#$*!@discussions.microsoft.com> wrote in message
>> > > news:4CC3BC9E-2AAC-4C6D-A2C2-171E48453273@microsoft.com...
>> > >> How do I sum a column in a table in Word 2007? New-fangled version is
>> > >> toooo
>> > >> complicated....
>> >
>> >
>> >

Graham Mayor · External Since: Jul 04, 2006 Posts: 4677

If there are amounts to sum in the column above the cell in which you want
to insert the total, clicking the formula button with the cursor in that
cell will offer to insert the =Sum(Above) by default. Hardly rocket science.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

macropod wrote:
> Hi,
>
> With the table cell where you want the sum to appear selected, click
> on the table 'Layout' Ribbon tab, then click the formula icon and
> type in your forumla (eg =SUM(ABOVE) or =SUM(A1:A5), or whatever else
> it is you need) and add the appropriate numeric formatting switch
> from the dropdown. Not at all difficult, really.
>
> "P.O.'d with Microsoft" <P.O.'d with
> Microsoft.RemoveThis@discussions.microsoft.com> wrote in message
> news:1771BB3C-3264-4D82-963F-336BF4FDEA91@microsoft.com...
>> I still can't get it to work!!! I loved Wordperfect, but gave it up
>> with my new Vista PC because I had to replace almost ALL my
>> software- at great expense (but that's another matter). What I CAN'T
>> BELIEVE is that Microsoft has decided that summing a column in Word
>> is not one of the most normal and NECESSARY functions. I KNOW that
>> I could remake my invoices to use Excell instead - but WHY SHOULD I
>> HAVE TO?? It is enough to make me decide to discard MS Office
>> altogether. I was happier with WordPerfect and Quattrro!! and if
>> all the $!%$@! thing needs is ONE SUM, why should I convert it? Even the
>> latest AutoCAD software has annoying features (or lack of
>> them) in Vista. "Rick@#$*!" wrote:
>>
>>> Thanks Summer and Rick both helpful replies.
>>>
>>> "Graham Mayor" wrote:
>>>
>>>> Or with the cursor in the cell where you want the calculation,
>>>> Insert > Quick Parts > Field > = (Formula field) and again
>>>> =Sum(Above) will be the default.
>>>> Note that with 'Summer's' method, the cursor has to be in the
>>>> table for the layout tab to appear on the ribbon.
>>>>
>>>> --
>>>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>>> Graham Mayor - Word MVP
>>>>
>>>> My web site www.gmayor.com
>>>> Word MVP web site http://word.mvps.org
>>>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>>>
>>>>
>>>> Summer wrote:
>>>>> If you have a column row with figures tab to next row and move to
>>>>> column you wish to Sum (there should already be at least one
>>>>> amount say "10" in the Sum column.
>>>>>
>>>>> Press Insert Layout Formula (end of ribbon) {= SUM(ABOVE } will
>>>>> appear Press ALT F9 to toggle this code view.
>>>>>
>>>>> Hope this helps.
>>>>>
>>>>> "Rick@#$*!" <Rick@#$*!@discussions.microsoft.com> wrote in message
>>>>> news:4CC3BC9E-2AAC-4C6D-A2C2-171E48453273@microsoft.com...
>>>>>> How do I sum a column in a table in Word 2007? New-fangled
>>>>>> version is toooo
>>>>>> complicated....