Help!

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

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Tables RSS
Next:  Help!! - help 25  
Author Message
Rick
External


Since: Jul 09, 2007
Posts: 1



PostPosted: Tue Jul 10, 2007 2:10 am    Post subject: How do I sum a column in a table in Word 2007?
Archived from groups: microsoft>public>word>tables (more info?)

How do I sum a column in a table in Word 2007? New-fangled version is toooo
complicated....
Back to top
Advertisement
Summer
External


Since: Jun 03, 2007
Posts: 211



PostPosted: Tue Jul 10, 2007 8:19 pm    Post subject: Re: How do I sum a column in a table in Word 2007?
Archived from groups: per prev. post (more info?)

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@#$*!" wrote in message

> How do I sum a column in a table in Word 2007? New-fangled version is
> toooo
> complicated....
Back to top
Graham Mayor
External


Since: Jul 04, 2006
Posts: 4874



PostPosted: Tue Jul 10, 2007 8:19 pm    Post subject: Re: How do I sum a column in a table in Word 2007?
Archived from groups: per prev. post (more info?)

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@#$*!" wrote in message
>
>> How do I sum a column in a table in Word 2007? New-fangled version is
>> toooo
>> complicated....
Back to top
Rick
External


Since: Jul 10, 2007
Posts: 1



PostPosted: Tue Jul 10, 2007 8:19 pm    Post subject: Re: How do I sum a column in a table in Word 2007?
Archived from groups: per prev. post (more info?)

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@#$*!" wrote in message
> >
> >> How do I sum a column in a table in Word 2007? New-fangled version is
> >> toooo
> >> complicated....
>
>
>
Back to top
Graham Mayor
External


Since: Jul 04, 2006
Posts: 4874



PostPosted: Tue Jul 10, 2007 8:19 pm    Post subject: Re: How do I sum a column in a table in Word 2007?
Archived from groups: per prev. post (more info?)

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@#$*!" wrote in message
>>>
>>>> How do I sum a column in a table in Word 2007? New-fangled version
>>>> is toooo
>>>> complicated....
Back to top
P.O.'d with Microsoft
External


Since: Jun 12, 2009
Posts: 1



PostPosted: Sat Jun 13, 2009 12:38 am    Post subject: Re: How do I sum a column in a table in Word 2007?
Archived from groups: per prev. post (more info?)

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@#$*!" wrote in message
> > >
> > >> How do I sum a column in a table in Word 2007? New-fangled version is
> > >> toooo
> > >> complicated....
> >
> >
> >
Back to top
macropod
External


Since: Jan 10, 2009
Posts: 157



PostPosted: Sat Jun 13, 2009 6:10 am    Post subject: Re: How do I sum a column in a table in Word 2007?
Archived from groups: per prev. post (more info?)

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" wrote in message

>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@#$*!" wrote in message
>> > >
>> > >> How do I sum a column in a table in Word 2007? New-fangled version is
>> > >> toooo
>> > >> complicated....
>> >
>> >
>> >
Back to top
Graham Mayor
External


Since: Jul 04, 2006
Posts: 4874



PostPosted: Sat Jun 13, 2009 7:10 am    Post subject: Re: How do I sum a column in a table in Word 2007?
Archived from groups: per prev. post (more info?)

Back to top
VAUTOUR 110
External


Since: Aug 30, 2006
Posts: 7



PostPosted: Sun May 16, 2010 9:05 pm    Post subject: Re: How do I sum a column in a table in Word 2007?
Archived from groups: per prev. post (more info?)

Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Mon May 17, 2010 2:10 am    Post subject: Re: How do I sum a column in a table in Word 2007?
Archived from groups: per prev. post (more info?)

Back to top
Graham Mayor
External


Since: Jul 04, 2006
Posts: 4874



PostPosted: Mon May 17, 2010 5:10 am    Post subject: Re: How do I sum a column in a table in Word 2007?
Archived from groups: per prev. post (more info?)

Back to top
Advertisement
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Tables
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum