Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-20-2009, 01:21 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 Auto-updating basic math functions & cross-referencing tables

I'm creating a form in Word where scores have to be tallied in multiple categories across nearly 15 pages. I'd like to set everything up so that the sums are calculated automatically but am having a few problems, as I've never used math functions in Word before:



1. When I use the basic "=SUM(A1:A15)" function, it does not automatically update the output if I input a new number in one of the affected cells. Excel performs this function dynamically, is there a way to do it in Word? Only option I see is manually right-clicking the formula and selecting "Update Field."

2. The first page of the document is a "Master Tally Sheet" that tracks results from all of the following pages. How do I reference the outputs from tables on these other pages? I only know how to get a formula to recognize data within a single table.

Attached is a sample document (just the first two pages, but you'll get the idea). The subtotal on every page has to be automatically feed back to page 1 - the Master Tally Sheet.

Thanks!
Attached Files
File Type: doc sample tally sheet.doc (60.0 KB, 18 views)
Reply With Quote
 

Thread Tools
Display Modes


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 10:19 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