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  

Adding numbers in a table with text fields



 
 
Thread Tools Display Modes
  #1  
Old March 23rd, 2006, 05:08 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Adding numbers in a table with text fields

I have a Table in Word 2002 that has text fields for entering values. I want
to enter a SUM formulaat the bottom of the table to add the values. The
formula does not work correctly. I tested it by entering the value "1" in
each text field. Instead of having the SUM formula show 1..2..3..4..5 as I
enter each "1", it shows 1..3..6..10..16. Each time I tab or move between
the text fields, the formula changes the value, whether I enter a number in
the text field or not.

What am I doing wrong?
  #2  
Old March 23rd, 2006, 08:21 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Adding numbers in a table with text fields

What formula are you using?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Zonkeraz" wrote in message
...
I have a Table in Word 2002 that has text fields for entering values. I
want
to enter a SUM formulaat the bottom of the table to add the values. The
formula does not work correctly. I tested it by entering the value "1" in
each text field. Instead of having the SUM formula show 1..2..3..4..5 as
I
enter each "1", it shows 1..3..6..10..16. Each time I tab or move between
the text fields, the formula changes the value, whether I enter a number
in
the text field or not.

What am I doing wrong?



  #3  
Old March 23rd, 2006, 08:40 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Adding numbers in a table with text fields

I tried various iterations of the =SUM formula. For example:
=SUM(b1:b5)
+b1+b2+b3+b4+b5

All of the variations reacted the same way when I entered numbers.

"Zonkeraz" wrote:

I have a Table in Word 2002 that has text fields for entering values. I want
to enter a SUM formula at the bottom of the table to add the values. The
formula does not work correctly. I tested it by entering the value "1" in
each text field. Instead of having the SUM formula show 1..2..3..4..5 as I
enter each "1", it shows 1..3..6..10..16. Each time I tab or move between
the text fields, the formula changes the value, whether I enter a number in
the text field or not.

What am I doing wrong?

  #4  
Old March 24th, 2006, 07:53 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Adding numbers in a table with text fields

Are the formfields in b1 through b5 used for text input or are they
themselves the result of a calculation of numbers entered into other
formfields.

I cannot replicate your problem either using =Sum(b1:b5), =Sum(above) or
=b1+b2+b3+b4+b5 when entering data directly into the formfields in those
cells.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Zonkeraz" wrote in message
...
I tried various iterations of the =SUM formula. For example:
=SUM(b1:b5)
+b1+b2+b3+b4+b5

All of the variations reacted the same way when I entered numbers.

"Zonkeraz" wrote:

I have a Table in Word 2002 that has text fields for entering values. I
want
to enter a SUM formula at the bottom of the table to add the values. The
formula does not work correctly. I tested it by entering the value "1"
in
each text field. Instead of having the SUM formula show 1..2..3..4..5 as
I
enter each "1", it shows 1..3..6..10..16. Each time I tab or move
between
the text fields, the formula changes the value, whether I enter a number
in
the text field or not.

What am I doing wrong?



  #5  
Old March 26th, 2006, 11:57 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Adding numbers in a table with text fields

They are "Text Form Fields" that I will just enter numerical values, they are
not formulas themselves.

I think I have partially solved the problem. I went into the "Properties"
of the text fields and made sure the "type" is set to "number". I then
unchecked the "calculate on exit" box. This seemed to work because when I
typed in the value "1" in each text field, the formula worked correctly and I
got "5" as my answer.

One problem remains: When I go back to clear the text fields, the formula
still shows a value of "5", not "0" like I want it to. When I put in new
numbers in the text fields, they get added to the "5".

How do I get the formula to return to a value of "0" when the text fields
are emptied?

"Zonkeraz" wrote:

I have a Table in Word 2002 that has text fields for entering values. I want
to enter a SUM formulaat the bottom of the table to add the values. The
formula does not work correctly. I tested it by entering the value "1" in
each text field. Instead of having the SUM formula show 1..2..3..4..5 as I
enter each "1", it shows 1..3..6..10..16. Each time I tab or move between
the text fields, the formula changes the value, whether I enter a number in
the text field or not.

What am I doing wrong?

  #6  
Old March 27th, 2006, 01:30 AM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Adding numbers in a table with text fields

The way this works is that you create a text form field for each number that
contributes to the calculation. You check "Calculate on exit" for that
field. This guarantees that the calculation field will be correct. For the
rest, see “WD2000: Calculation in Form Field Shows Wrong Result” at
http://support.microsoft.com/?kbid=211253

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Zonkeraz" wrote in message
...
They are "Text Form Fields" that I will just enter numerical values, they

are
not formulas themselves.

I think I have partially solved the problem. I went into the "Properties"
of the text fields and made sure the "type" is set to "number". I then
unchecked the "calculate on exit" box. This seemed to work because when I
typed in the value "1" in each text field, the formula worked correctly

and I
got "5" as my answer.

One problem remains: When I go back to clear the text fields, the formula
still shows a value of "5", not "0" like I want it to. When I put in new
numbers in the text fields, they get added to the "5".

How do I get the formula to return to a value of "0" when the text fields
are emptied?

"Zonkeraz" wrote:

I have a Table in Word 2002 that has text fields for entering values. I

want
to enter a SUM formulaat the bottom of the table to add the values. The
formula does not work correctly. I tested it by entering the value "1"

in
each text field. Instead of having the SUM formula show 1..2..3..4..5

as I
enter each "1", it shows 1..3..6..10..16. Each time I tab or move

between
the text fields, the formula changes the value, whether I enter a number

in
the text field or not.

What am I doing wrong?


  #7  
Old March 27th, 2006, 07:45 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Adding numbers in a table with text fields

Suzanne,

Thanks for your feedback. I formatted the table just as you discussed and
it still would not work. Out of desperation I decided to delete the entire
table and recreate it. When I did that, everything worked as you said it
would. Evidently there was some quirky formatting miscue in the original
that I could not find to correct.

Bottom line is that the table works properly now. Thanks again!

Zonkeraz

"Suzanne S. Barnhill" wrote:

The way this works is that you create a text form field for each number that
contributes to the calculation. You check "Calculate on exit" for that
field. This guarantees that the calculation field will be correct. For the
rest, see “WD2000: Calculation in Form Field Shows Wrong Result” at
http://support.microsoft.com/?kbid=211253

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Zonkeraz" wrote in message
...
They are "Text Form Fields" that I will just enter numerical values, they

are
not formulas themselves.

I think I have partially solved the problem. I went into the "Properties"
of the text fields and made sure the "type" is set to "number". I then
unchecked the "calculate on exit" box. This seemed to work because when I
typed in the value "1" in each text field, the formula worked correctly

and I
got "5" as my answer.

One problem remains: When I go back to clear the text fields, the formula
still shows a value of "5", not "0" like I want it to. When I put in new
numbers in the text fields, they get added to the "5".

How do I get the formula to return to a value of "0" when the text fields
are emptied?

"Zonkeraz" wrote:

I have a Table in Word 2002 that has text fields for entering values. I

want
to enter a SUM formulaat the bottom of the table to add the values. The
formula does not work correctly. I tested it by entering the value "1"

in
each text field. Instead of having the SUM formula show 1..2..3..4..5

as I
enter each "1", it shows 1..3..6..10..16. Each time I tab or move

between
the text fields, the formula changes the value, whether I enter a number

in
the text field or not.

What am I doing wrong?



  #8  
Old March 27th, 2006, 10:08 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Adding numbers in a table with text fields

Sometimes the mysteries of Word are too great for mortals to comprehend.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Zonkeraz" wrote in message
...
Suzanne,

Thanks for your feedback. I formatted the table just as you discussed and
it still would not work. Out of desperation I decided to delete the

entire
table and recreate it. When I did that, everything worked as you said it
would. Evidently there was some quirky formatting miscue in the original
that I could not find to correct.

Bottom line is that the table works properly now. Thanks again!

Zonkeraz

"Suzanne S. Barnhill" wrote:

The way this works is that you create a text form field for each number

that
contributes to the calculation. You check "Calculate on exit" for that
field. This guarantees that the calculation field will be correct. For

the
rest, see “WD2000: Calculation in Form Field Shows Wrong Result” at
http://support.microsoft.com/?kbid=211253

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"Zonkeraz" wrote in message
...
They are "Text Form Fields" that I will just enter numerical values,

they
are
not formulas themselves.

I think I have partially solved the problem. I went into the

"Properties"
of the text fields and made sure the "type" is set to "number". I

then
unchecked the "calculate on exit" box. This seemed to work because

when I
typed in the value "1" in each text field, the formula worked

correctly
and I
got "5" as my answer.

One problem remains: When I go back to clear the text fields, the

formula
still shows a value of "5", not "0" like I want it to. When I put in

new
numbers in the text fields, they get added to the "5".

How do I get the formula to return to a value of "0" when the text

fields
are emptied?

"Zonkeraz" wrote:

I have a Table in Word 2002 that has text fields for entering

values. I
want
to enter a SUM formulaat the bottom of the table to add the values.

The
formula does not work correctly. I tested it by entering the value

"1"
in
each text field. Instead of having the SUM formula show

1..2..3..4..5
as I
enter each "1", it shows 1..3..6..10..16. Each time I tab or move

between
the text fields, the formula changes the value, whether I enter a

number
in
the text field or not.

What am I doing wrong?




 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie Looking for Help Little Penny Using Forms 6 December 27th, 2005 09:33 PM
Word applies direct format on File open Uriel General Discussion 16 November 27th, 2005 08:22 PM
pass a calculated form field to a subform field? Brook Using Forms 22 April 28th, 2005 04:56 PM
Ideas On Producing Envelopes & Labels For Data RNUSZ@OKDPS Setting Up & Running Reports 0 April 28th, 2005 03:22 PM
Access reports with a horizontal line after each record??? Bill via AccessMonster.com Setting Up & Running Reports 6 March 9th, 2005 05:51 PM


All times are GMT +1. The time now is 03:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.