A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old July 10th, 2007, 06:10 AM posted to microsoft.public.word.tables
Rick@#$*!
external usenet poster
 
Posts: 1
Default How do I sum a column in a table in Word 2007?

How do I sum a column in a table in Word 2007? New-fangled version is toooo
complicated....
  #2  
Old July 10th, 2007, 07:19 AM posted to microsoft.public.word.tables
Summer[_4_]
external usenet poster
 
Posts: 343
Default How do I sum a column in a table in Word 2007?

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....



  #3  
Old July 10th, 2007, 08:08 AM posted to microsoft.public.word.tables
Graham Mayor
external usenet poster
 
Posts: 18,297
Default How do I sum a column in a table in Word 2007?

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....



  #4  
Old July 10th, 2007, 08:20 AM posted to microsoft.public.word.tables
Rick@#$*![_2_]
external usenet poster
 
Posts: 1
Default How do I sum a column in a table in Word 2007?

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....




  #5  
Old July 10th, 2007, 08:59 AM posted to microsoft.public.word.tables
Graham Mayor
external usenet poster
 
Posts: 18,297
Default How do I sum a column in a table in Word 2007?

I thought you were Rick?

--

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....



  #6  
Old June 13th, 2009, 04:38 AM posted to microsoft.public.word.tables
P.O.'d with Microsoft
external usenet poster
 
Posts: 1
Default How do I sum a column in a table in Word 2007?

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....




  #7  
Old June 13th, 2009, 06:20 AM posted to microsoft.public.word.tables
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default How do I sum a column in a table in Word 2007?

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 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....




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.