Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2009, 10:05 AM
DMD DMD is offline Auto-updating basic math functions & cross-referencing tables Windows Vista Auto-updating basic math functions & cross-referencing tables Office 2007
Novice
 
Join Date: Nov 2009
Location: Iowa
Posts: 14
DMD is on a distinguished road
Default


Quote:
Originally Posted by FranklinBluth View Post
Nope. Never got a response and it wasn't crucial for work purposes so I forgot about it.

Thank you very much for your reply.
Reply With Quote
  #2  
Old 11-18-2009, 01:29 PM
FranklinBluth FranklinBluth is offline Auto-updating basic math functions & cross-referencing tables Windows XP Auto-updating basic math functions & cross-referencing tables Office 2003
Novice
Auto-updating basic math functions & cross-referencing tables
 
Join Date: Jul 2009
Posts: 6
FranklinBluth is on a distinguished road
Default Think I got it

So I did some more quick Google-ing and I think I got it now...

1. Create a table in Word - the cells are identified the same as they are in Excel, Word just won't show it explicitly (A1, A2, B1, B2, etc.)

2. Use the Text Form Field to insert fields where your numbers will go. Make sure you select "Calculate on Exit" in the Form Field Options for each one. This allows auto-calculations to occur where you will have your function.

3. Table-->Formula or Insert-->Field-->Formula in the cell where you want your final calculation to be done.

Full tutorial here

This only works within single tables, not across multiple tables, which still doesn't completely solve my problem.
Reply With Quote
  #3  
Old 11-18-2009, 04:29 PM
DMD DMD is offline Auto-updating basic math functions & cross-referencing tables Windows Vista Auto-updating basic math functions & cross-referencing tables Office 2007
Novice
 
Join Date: Nov 2009
Location: Iowa
Posts: 14
DMD is on a distinguished road
Default

Quote:
Originally Posted by FranklinBluth View Post
So I did some more quick Google-ing and I think I got it now...

1. Create a table in Word - the cells are identified the same as they are in Excel, Word just won't show it explicitly (A1, A2, B1, B2, etc.)

2. Use the Text Form Field to insert fields where your numbers will go. Make sure you select "Calculate on Exit" in the Form Field Options for each one. This allows auto-calculations to occur where you will have your function.

3. Table-->Formula or Insert-->Field-->Formula in the cell where you want your final calculation to be done.

Full tutorial here

This only works within single tables, not across multiple tables, which still doesn't completely solve my problem.
First: Thank you for taking the effort to find more info. I am only using
a single table, but apparently the options for Word 2003 are different
from 2007. I don't have the "field" or "formula" options. When I try
"equation" and put =sum(above) in the cell where I want my total;
those very words and symbols stay in the cell and there is no math
calculation. I tried enter numbers in the cells above, but no total
appeared? Thanks again
Reply With Quote
  #4  
Old 11-18-2009, 05:41 PM
FranklinBluth FranklinBluth is offline Auto-updating basic math functions & cross-referencing tables Windows XP Auto-updating basic math functions & cross-referencing tables Office 2003
Novice
Auto-updating basic math functions & cross-referencing tables
 
Join Date: Jul 2009
Posts: 6
FranklinBluth is on a distinguished road
Default

Quote:
Originally Posted by DMD View Post
First: Thank you for taking the effort to find more info. I am only using
a single table, but apparently the options for Word 2003 are different
from 2007. I don't have the "field" or "formula" options. When I try
"equation" and put =sum(above) in the cell where I want my total;
those very words and symbols stay in the cell and there is no math
calculation. I tried enter numbers in the cells above, but no total
appeared? Thanks again
I'm using Word 2003 too. To enter a formula you need to select either Table --> Formula or Insert --> Field (Formula). Then you can type "=SUM(above)" or whatever you want.

You don't have these options at all??
Reply With Quote
  #5  
Old 11-18-2009, 05:48 PM
DMD DMD is offline Auto-updating basic math functions & cross-referencing tables Windows Vista Auto-updating basic math functions & cross-referencing tables Office 2007
Novice
 
Join Date: Nov 2009
Location: Iowa
Posts: 14
DMD is on a distinguished road
Default

Quote:
Originally Posted by FranklinBluth View Post
I'm using Word 2003 too. To enter a formula you need to select either Table --> Formula or Insert --> Field (Formula). Then you can type "=SUM(above)" or whatever you want.

You don't have these options at all??
No. notice on the header, next to my name - I have Vista
and Word 2007.
Reply With Quote
  #6  
Old 11-18-2009, 05:51 PM
FranklinBluth FranklinBluth is offline Auto-updating basic math functions & cross-referencing tables Windows XP Auto-updating basic math functions & cross-referencing tables Office 2003
Novice
Auto-updating basic math functions & cross-referencing tables
 
Join Date: Jul 2009
Posts: 6
FranklinBluth is on a distinguished road
Default

Oh my bad, I misunderstood.
I'm not sure how 2007 handles it unfortunately, sorry.
Reply With Quote
  #7  
Old 11-18-2009, 06:06 PM
DMD DMD is offline Auto-updating basic math functions & cross-referencing tables Windows Vista Auto-updating basic math functions & cross-referencing tables Office 2007
Novice
 
Join Date: Nov 2009
Location: Iowa
Posts: 14
DMD is on a distinguished road
Default

Quote:
Originally Posted by FranklinBluth View Post
Oh my bad, I misunderstood.
I'm not sure how 2007 handles it unfortunately, sorry.
Thanks for trying. I've searched various places for 2007 help.
They all say pretty much the same thing, then show examples
for real complicated calculations like trigonometry. When I
try simple addition, it doesn't work. I appreciate your effort.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto referencing SharkAttack Word 5 02-17-2013 07:09 PM
Cross referencing maltesedog Word 0 02-13-2009 07:43 AM
Trouble updating a form TomCaesar Outlook 0 11-29-2006 10:52 AM
Auto-updating basic math functions & cross-referencing tables Error updating DC with WSUS karel Project 1 08-10-2006 06:19 AM
How to show help for addin functions? Movses Asatryan Excel 0 03-02-2006 05:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:21 PM.


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