Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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,525
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
 

Thread Tools
Display Modes


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 11:05 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