Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-30-2013, 06:58 AM
Evolta Evolta is offline Use field for product table Windows 7 64bit Use field for product table Office 2010 64bit
Novice
Use field for product table
 
Join Date: Oct 2013
Posts: 15
Evolta is on a distinguished road
Default Use field for product table

Hello all,



I have a problem with word 2010 (at least I think it is 2010).

I have a table with following values: [10][12]
Now I want a field to multiply them.

{=SUM(Table1 A1)*SUM(Table1 B1)}

Now... I don't know, but why do I need to put SUM there?
Is there a more elegant way?

Just trying to learn some things about fields since I might need them in some templates later on in the process.

Thanks in advance
Reply With Quote
  #2  
Old 10-30-2013, 10:55 AM
Charles Kenyon Charles Kenyon is offline Use field for product table Windows 7 64bit Use field for product table Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,454
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Unless you need Word's other formatting features, field calculations are almost always better done in Excel.

Otherwise, please refer to
Microsoft Word Field Maths Tutorial


which I consider the authority on the subject.
Reply With Quote
  #3  
Old 10-30-2013, 10:52 PM
macropod's Avatar
macropod macropod is offline Use field for product table Windows 7 32bit Use field for product table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Evolta View Post
I have a table with following values: [10][12]
Now I want a field to multiply them.

{=SUM(Table1 A1)*SUM(Table1 B1)}

Now... I don't know, but why do I need to put SUM there?
Is there a more elegant way?
You need the 'SUM' to tell Word what to do with the bracketed expression.

FWIW, you could also use:
{=Product(Table1 A1, Table1 B1)}

To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
http://windowssecrets.com/forums/sho...Maths-Tutorial
or
http://www.gmayor.com/downloads.htm#Third_party
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 10-31-2013, 12:11 AM
Evolta Evolta is offline Use field for product table Windows 7 64bit Use field for product table Office 2010 64bit
Novice
Use field for product table
 
Join Date: Oct 2013
Posts: 15
Evolta is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
FWIW, you could also use:
{=Product(Table1 A1, Table1 B1)}
That was what I thought, but it did not work.
Since you also told me that this should work, I tried looking at it again.

problem: seperators.
I had to use ; instead of ,

Thanks for your reply
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining two pieces of VBA to create caption field above table lsmcal1984 Word VBA 1 08-16-2013 04:12 AM
Use field for product table Excel vba adding field in word table/shape in a header Hdr Excel 1 02-04-2013 04:40 PM
Field not showing in Pivot Table Field List kmcovington Excel 0 10-26-2012 10:14 AM
Excel Pivot Table Calculated Field BertLady Excel 0 05-21-2012 10:51 AM
Use field for product table IF Check Field and return content (Small DB-table) Spanec Excel 8 01-12-2012 06:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft