Reply
 
Thread Tools Display Modes
  #1   Report Post  
Anne Gilmour
 
Posts: n/a
Default Formula in table - Creating a final total from sub-total cells

I have a table in a word 97 form. I have inserted simple addition and
multiplication calculations which total automatically and they have worked
successfully, giving subtotal amounts.
However, now I would like a final total at the bottom of the table. This
final total will come from the sub totals (which is a cell in every second
row, which already has a formula attached).
No matter what formula I put in, the final total still stays at zero and
will not update. The 'final total' cell is clicked to update on exit.
I'm using bookmarks to reference cells in the table and I want the cells to
update automatically. I think I'm probably just getting the formula wrong - I
would really appreciate your help.
  #2   Report Post  
macropod
 
Posts: n/a
Default

hi Anne,

For your totals, you don't need another form field. What you need is a
formula field, in the form of:
{=a2+a4+a6+a8}
where 'a' defines the column in your table, and 2,4,6,8 etc define the row
numbers to be added.

Alternatively, you could use the formfield bookmarks, as in:
{={text1}+{text2}+{text3}+{text4}}

Having 'calculate on exit checked for the other formfields should be
sufficient to cause the total to re-calculate whenever any of its components
change.

Cheers
PS: The field braces for the formula are created via Ctrl-F9.


"Anne Gilmour" Anne wrote in message
news
I have a table in a word 97 form. I have inserted simple addition and
multiplication calculations which total automatically and they have worked
successfully, giving subtotal amounts.
However, now I would like a final total at the bottom of the table. This
final total will come from the sub totals (which is a cell in every second
row, which already has a formula attached).
No matter what formula I put in, the final total still stays at zero and
will not update. The 'final total' cell is clicked to update on exit.
I'm using bookmarks to reference cells in the table and I want the cells

to
update automatically. I think I'm probably just getting the formula

wrong - I
would really appreciate your help.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 1/11/2004


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Resources for Long Document Management Jason Langkamer-Smith Microsoft Word Help 9 January 17th 05 08:17 PM
Making a Form :: Line Borders / Table Cells with Flowing Text John Microsoft Word Help 1 January 2nd 05 02:42 PM
How do I link cells in a table? Tonia Tables 1 November 3rd 04 09:55 PM


All times are GMT +1. The time now is 06:48 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"