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  

Formulas: Subtracting totals of different tables



 
 
Thread Tools Display Modes
  #1  
Old June 2nd, 2004, 03:31 PM
Tiffany Grace
external usenet poster
 
Posts: n/a
Default Formulas: Subtracting totals of different tables

I am trying to take the total of one table and subtract the total of another table. I have bookmarked the tables as Table3 and Table4. I was wondering if someone could give me an example of the formula I would use. I have tried different ways but I get the message undefined bookmark or incorrect symbol. Any Help would be greatly appreciated.

Thank you.
  #2  
Old June 2nd, 2004, 05:18 PM
DDM
external usenet poster
 
Posts: n/a
Default Formulas: Subtracting totals of different tables

Tiffany, here's how I got it to work for me:

1-I created two tables, put in some numbers, then used the Table Formula
command to get the sums.
2-I selected the cells with the sums and bookmarked them, naming them
"first" and "second" (clever, no?)
3-I inserted a formula field (Insert Field Equations and Formulas =
(Formula)), and, in the box at the bottom of the Field dialog box, I entered
"first-second," without the quotes, of course.
4-I clicked OK, and it gave me my result.

When I went to Tools Options View Bookmarks) I saw that Word had
bookmarked my sums from Step 2 above thus: []. I right-clicked my field from
Step 3 and selected Toggle Field Codes and this is what it revealed:
{=first-second\*MERGEFORMAT}.

Hope this helps.

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


"Tiffany Grace" wrote in message
...
I am trying to take the total of one table and subtract the total of

another table. I have bookmarked the tables as Table3 and Table4. I was
wondering if someone could give me an example of the formula I would use. I
have tried different ways but I get the message undefined bookmark or
incorrect symbol. Any Help would be greatly appreciated.

Thank you.



  #3  
Old June 2nd, 2004, 05:46 PM
Tiffany Grace
external usenet poster
 
Posts: n/a
Default Formulas: Subtracting totals of different tables

Thank you so much that worked!
  #4  
Old June 5th, 2004, 12:22 PM
macropod
external usenet poster
 
Posts: n/a
Default Formulas: Subtracting totals of different tables

If the 'total' on each of the two tables is the sum of all cells above,
you could use a formula coded like:

{=SUM(Table3 B:B)/2+SUM(Table4 B:B)/2}
where the braces are created via Ctrl-F9.

For more information on Word field maths, see:
http://www.wopr.com/cgi-bin/w3t/show...&Number=365442
(url all one line)

Cheers


---
Message posted from http://www.ExcelForum.com/

 




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 02:56 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.