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  

Getting a table to total columns



 
 
Thread Tools Display Modes
  #1  
Old October 8th, 2008, 11:56 PM posted to microsoft.public.word.tables
Ross
external usenet poster
 
Posts: 297
Default Getting a table to total columns

Hi,

It's not for lack of trying to find the answer but after 20 minutes of
trying to figure out how to total columns in a Word 2007 table, I have
failed. Can anyone point me to some documentation (or better yet just tell
me) how to correctly insert a formula that will total columns in a table.

Thanks in advance for your help.

RS
  #2  
Old October 9th, 2008, 12:17 AM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Getting a table to total columns

This isn't any different from previous versions, is it? On the Layout tab of
the contextual Table Tools there is a Formula button. The formula defaults
to SUM(ABOVE) or SUM(LEFT) if you have values in the relevant cells. You can
also add the AutoSum button to the QAT. Or you can use Insert | Text | Quick
Parts | Field | Formula.

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

"Ross" wrote in message
...
Hi,

It's not for lack of trying to find the answer but after 20 minutes of
trying to figure out how to total columns in a Word 2007 table, I have
failed. Can anyone point me to some documentation (or better yet just tell
me) how to correctly insert a formula that will total columns in a table.

Thanks in advance for your help.

RS



  #3  
Old October 9th, 2008, 12:46 AM posted to microsoft.public.word.tables
Ross
external usenet poster
 
Posts: 297
Default Getting a table to total columns

Thanks Suzanne.

Is there a way update all formula fields at once or do you need to right
mouse click on each formula to update the fields in a table? I guess I am
looking for the ability to do the same thing with formulas that you can do
with a Table of Contents where you can update the entire table at once. Hope
this makes sense.

RS

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it? On the Layout tab of
the contextual Table Tools there is a Formula button. The formula defaults
to SUM(ABOVE) or SUM(LEFT) if you have values in the relevant cells. You can
also add the AutoSum button to the QAT. Or you can use Insert | Text | Quick
Parts | Field | Formula.

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

"Ross" wrote in message
...
Hi,

It's not for lack of trying to find the answer but after 20 minutes of
trying to figure out how to total columns in a Word 2007 table, I have
failed. Can anyone point me to some documentation (or better yet just tell
me) how to correctly insert a formula that will total columns in a table.

Thanks in advance for your help.

RS




  #4  
Old October 9th, 2008, 05:16 AM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Getting a table to total columns

Ctrl+A, F9, or switch to Print Preview.

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

"Ross" wrote in message
...
Thanks Suzanne.

Is there a way update all formula fields at once or do you need to right
mouse click on each formula to update the fields in a table? I guess I am
looking for the ability to do the same thing with formulas that you can do
with a Table of Contents where you can update the entire table at once.
Hope
this makes sense.

RS

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it? On the Layout tab
of
the contextual Table Tools there is a Formula button. The formula
defaults
to SUM(ABOVE) or SUM(LEFT) if you have values in the relevant cells. You
can
also add the AutoSum button to the QAT. Or you can use Insert | Text |
Quick
Parts | Field | Formula.

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

"Ross" wrote in message
...
Hi,

It's not for lack of trying to find the answer but after 20 minutes of
trying to figure out how to total columns in a Word 2007 table, I have
failed. Can anyone point me to some documentation (or better yet just
tell
me) how to correctly insert a formula that will total columns in a
table.

Thanks in advance for your help.

RS







  #5  
Old May 12th, 2009, 03:07 AM posted to microsoft.public.word.tables
RichardB43
external usenet poster
 
Posts: 1
Default Getting a table to total columns

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?


Like everything else in the new version (I've used it maybe 1 year now,
still find it abysmal for navigation), it is a hell of a lot harder to find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your document look
pretty, but as for useability, it was a huge retrograde step!
  #6  
Old June 3rd, 2009, 10:35 PM posted to microsoft.public.word.tables
Willem Nel
external usenet poster
 
Posts: 12
Default Getting a table to total columns

Ctrl+A, F9 works in template (not protected). When the form is with a
customer or user no formulas operates the way it shoud. I have studied
template online tutorials etc. Could not find a solution. Can any one help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?


Like everything else in the new version (I've used it maybe 1 year now,
still find it abysmal for navigation), it is a hell of a lot harder to find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your document look
pretty, but as for useability, it was a huge retrograde step!

  #7  
Old June 3rd, 2009, 10:53 PM posted to microsoft.public.word.tables
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Getting a table to total columns

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is with a
customer or user no formulas operates the way it shoud. I have studied
template online tutorials etc. Could not find a solution. Can any one
help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?


Like everything else in the new version (I've used it maybe 1 year now,
still find it abysmal for navigation), it is a hell of a lot harder to
find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your document look
pretty, but as for useability, it was a huge retrograde step!


  #8  
Old June 3rd, 2009, 11:10 PM posted to microsoft.public.word.tables
Willem Nel
external usenet poster
 
Posts: 12
Default Getting a table to total columns

In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is recorded when
formula is set. There after ctrl+a, f9 updates field in template. If template
is protected or saved as word document A3 never changes when A1 OR A2
changes. Ctrl+a, F9 or right click also does not work. Form with calculation
of no use to customers or our company! Need to get A3 formula to automaticly
update when A1 OR A2 changes if template is protected or saved as word
document. See book-keeping slip template under forms on online templates.
This is what formulas should do! Book-keeping slip is protected and cannot
see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is with a
customer or user no formulas operates the way it shoud. I have studied
template online tutorials etc. Could not find a solution. Can any one
help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it maybe 1 year now,
still find it abysmal for navigation), it is a hell of a lot harder to
find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your document look
pretty, but as for useability, it was a huge retrograde step!



  #9  
Old June 4th, 2009, 05:04 AM posted to microsoft.public.word.tables
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Getting a table to total columns

Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit
property of each. Assuming that you name bookmarks assigned to those fields
as A1 and a2, in A3, insert a calculation type formfield that contains the
expression =A1 * A2

See the following;

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is recorded when
formula is set. There after ctrl+a, f9 updates field in template. If
template
is protected or saved as word document A3 never changes when A1 OR A2
changes. Ctrl+a, F9 or right click also does not work. Form with
calculation
of no use to customers or our company! Need to get A3 formula to
automaticly
update when A1 OR A2 changes if template is protected or saved as word
document. See book-keeping slip template under forms on online templates.
This is what formulas should do! Book-keeping slip is protected and cannot
see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is with a
customer or user no formulas operates the way it shoud. I have studied
template online tutorials etc. Could not find a solution. Can any one
help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it maybe 1 year
now,
still find it abysmal for navigation), it is a hell of a lot harder to
find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your document look
pretty, but as for useability, it was a huge retrograde step!




  #10  
Old June 4th, 2009, 12:38 PM posted to microsoft.public.word.tables
Willem Nel
external usenet poster
 
Posts: 12
Default Getting a table to total columns

Thanks Doug!!! Form calculations now running smooth! Need one more input from
you, please. How do I get the result of a calculation to not show 0. I want
the field to be blank if result is 0.


--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit
property of each. Assuming that you name bookmarks assigned to those fields
as A1 and a2, in A3, insert a calculation type formfield that contains the
expression =A1 * A2

See the following;

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is recorded when
formula is set. There after ctrl+a, f9 updates field in template. If
template
is protected or saved as word document A3 never changes when A1 OR A2
changes. Ctrl+a, F9 or right click also does not work. Form with
calculation
of no use to customers or our company! Need to get A3 formula to
automaticly
update when A1 OR A2 changes if template is protected or saved as word
document. See book-keeping slip template under forms on online templates.
This is what formulas should do! Book-keeping slip is protected and cannot
see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is with a
customer or user no formulas operates the way it shoud. I have studied
template online tutorials etc. Could not find a solution. Can any one
help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it maybe 1 year
now,
still find it abysmal for navigation), it is a hell of a lot harder to
find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your document look
pretty, but as for useability, it was a huge retrograde step!




 




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 12:00 AM.


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